Hi,
I’m testing OH3.0.1 (docker version) with influxdb 1.8.3.
Persistence works very well with the following settings:
influxdb.persist
...
gpTemperature* : strategy = everyUpdate
gpPower* -> "power" : strategy = everyChange
and those items
test.items
Number:Power Pwr_Shly1 "Cons. instant. [%.1f %unit%]" <energy>
(geLight, gpPower) ["Measurement", "Power"]
{ channel="shelly:shellyplugs:6a5cc9:meter#currentWatts" }
Number:Temperature Tmp_EnOcean1 "Temp. EnOcean [%.1f %unit%]" <temperature>
(geThermoEO, gpTemperature) ["Measurement", "Temperature"]
{ channel="enocean:temperatureSensor:FTXMIIG5:demoTemp:temperature" }
When I query the database I get the data as expected :
> select * from Tmp_EnOcean1 order by time desc limit 5
name: Tmp_EnOcean1
time item value
---- ---- -----
2021-01-31T08:10:45.946Z Tmp_EnOcean1 20.862745098039216
2021-01-31T07:53:15.855Z Tmp_EnOcean1 20.862745098039216
2021-01-31T07:35:45.441Z Tmp_EnOcean1 21.333333333333332
2021-01-31T05:07:12.139Z Tmp_EnOcean1 20.54901960784314
2021-01-31T04:51:27.372Z Tmp_EnOcean1 20.07843137254902
> select * from power order by time desc limit 5
name: power
time item value
---- ---- -----
2021-01-31T08:07:32.359Z Pwr_Shly1 0
2021-01-31T08:06:32.191Z Pwr_Shly1 21.5
2021-01-31T08:05:32.01Z Pwr_Shly1 21.6
2021-01-31T08:04:31.832Z Pwr_Shly1 21.5
2021-01-31T08:02:31.472Z Pwr_Shly1 21.6
But in the UI, there is no chart data for the aliased “Pwr_Shly1” item, opposite to “Tmp_EnOcean1”.
It seems that the data are queried by item name in both case: here are the queries logged by influxdb:
For the non aliased item:
ts=2021-01-31T08:37:18.560153Z lvl=info msg="Executing query" log_id=0S1u9Kn0000 service=query query="SELECT value FROM appart.autogen.Tmp_EnOcean1 WHERE time >= '2021-01-30T08:36:58.447Z' AND time <= '2021-01-31T08:36:58.446Z' ORDER BY time ASC"
And for the aliased one:
ts=2021-01-31T08:37:41.207569Z lvl=info msg="Executing query" log_id=0S1u9Kn0000 service=query query="SELECT value FROM appart.autogen.Pwr_Shly1 WHERE time >= '2021-01-30T08:37:21.103Z' AND time <= '2021-01-31T08:37:21.102Z' ORDER BY time ASC"
Hope it helps. Aliasing is a nice feature when downsampling.
Best regards and thanks for this great job !