Hello all,
I got a container with 3 widget that read data from the same table “tubes”.
I need to show data base the WHERE clause on data time field time_out_04 . See image to understand better…
My needing is to show records in second widget until time has passed and time_out_04 has a content (datatime). More or less it works .
My big issue it’s show data on W3 when the records disappear from W2 becouse time frame is passed. I tried to use a reload of 60 sec but it doesn’t work properly.
I really don’t know how to sort out that … The record appears in the same time on W2 and W3 for a while…
Someone of you gurus are able to make the trick ? I’m stucked… thanks
1st W1 —> WHERE time_out_04 IS NULL
Reload time 5 sec
2nd W2 —> WHERE time_out_04 IS NOT NULL AND time_out_04 > DATE_SUB( NOW( ) , INTERVAL 5 SECOND )
Reload time 5 sec
3rd W3 ----> WHERE time_out_04 IS NOT NULL AND time_out_04 >= DATE_SUB( NOW( ) , INTERVAL 12 HOUR) AND time_out_04 <= DATE_SUB( NOW( ) , INTERVAL 15 SECOND)
Reload time 60 sec
