I’ve created 3 continuous queries with the following pattern yesterday:
CREATE CONTINUOUS QUERY "PVEnergyFeedPerDayQuery" ON "openhab" BEGIN SELECT max(value)-min(value) INTO "PvEnergyFeedPerDay" FROM "openhab"."default"."evs_0281" GROUP BY time(1d) END
The result sets have been created after a while but when querying them I’ve only got an empty result set.
Any ideas what went wrong?