JensH
(Jens H)
November 9, 2020, 8:32pm
2
Some late, just saw your post while searching something else. Here is an example for deleting old values from persistence (configured or some later: all older than x days):
Out of Date: New Version later in Thread
Based on examples in this Thread I put all hints and further usefull things together:
If you want to cleanup Old Item-Data all code can be send directly in SQL-Database. For jdbc-mysql-persistence all Commands have to be send in SQL (for example in SQL Window in phpmyadmin). has to be changed to your exact table name, you can see in phpmyadmin.
Following Examples are tested with OH 2.5 SNAPSHOT 1680:
1) Alter Table for Items to set maximal history of…