I have a ticker on a layout displaying menu items for a canteen. It evaluates the filter using this SQL:
DATE_FORMAT(NOW(), “%T”) > ServingTimeStart AND DATE_FORMAT(NOW(), “%T”) < ServingTimeEnd AND DATE_FORMAT(NOW(), “%W”) = Day
All works fine in the layout designer, and everything shows as it should (including a blank screen out of hours) however, on the display the menu does not change, as if the statement is never reevaluated, even though I have set the length of the ticker to 5 seconds and the refresh interval to one minute.
If i resize anything on the layout designer and save this, it forces the correct update.