Hi,
I want to query the database Group by time ( default shift time )
SELECT (Max(“field1”)) FROM " Measurement1" WHERE (“id” = ‘01’) AND $timeFilter GROUP BY time (Shift time) fill (null)
Example:
Shift time 1: 9:00 AM to 5 :00 pm
Shift time 2: 05:01 PM to 01:00 AM
Shift time 3: 01:01 PM to 08:59 AM
And
Shift time: 09:00 AM to 09:00 AM ( Today to Next day, 24 hrs
I want to result like this
For Shift time
01/03/2021… Shift time1 reault1
01/03/2021… Shift time2 result 2
01/03/2021… Shift time3 result3
02/03/2021… Shift time1 reault1
02/03/2021… Shift time2 result 2
02/03/2021… Shift time3 result3
Any one implemented this function.