Announcement

Collapse
No announcement yet.

How show records coordinating the 3 widget ??

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How show records coordinating the 3 widget ??

    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

    Attached Files
Working...
X