Persistence Question

Hi all,

I have configured the persistence for the group of temperatures in all my rooms.
This is the configuration:

Group:Number:AVG gTemperature "Temperatura" <temperature> (Home)

gTemperature : strategy = everyChange

I’m using sqlite for the persistence and in the database I see, for example:

sqlite> select * from item0010;
2018-04-30 11:19:27.545|21.4
2018-04-30 11:29:50.019|21.5
2018-04-30 11:36:05.963|21.6
2018-04-30 11:38:24.623|21.7
2018-04-30 11:55:14.957|21.8
2018-04-30 12:17:09.487|21.9
2018-04-30 12:18:09.174|21.8
2018-04-30 12:18:11.697|21.9
2018-04-30 12:21:07.396|22.0
2018-04-30 12:29:05.625|22.1
2018-04-30 12:47:10.575|22.3
2018-04-30 13:42:50.971|22.4
2018-04-30 13:45:31.296|22.5
2018-04-30 13:48:46.334|22.7
2018-04-30 13:57:21.060|22.5

I expected to have both the temperature and the indication of associated item.

How can I have this ?


One of the tables in your sqlite database will have the link between the item name and the related table name. This persistence service just works like that

This is clear when I have a single Item, but in this case I have a group of Items.

If I need to thrack the temparature of all the room I havo to persist the single Items, in this case I’ll have as much tables as nte number of items.

Is this the correct way ?

I can use this sintax:

Temperature1,Temperature2,Temperature3,Temperature4 : strategy = everyChange

Is correct ?

Actually you are only persisting the Group Item’s state. If you want to persist the state of gTemperature and all the members of gTemperature you need to use:

gTemperature,gTemperature* : strategy = everyChange

gTemperature* means “all members of gTemperature”.