Query tag to alleviate some query workloads on perspective pages

'{[~]Shifts/Current Shift Start}' > '2022-01-25 07:00:00'

But, still might not work because the date/time will be formatted using java's style.

Consider not using a query tag. Use a memory tag, and use a gateway tag change event on shift start to run a PrepQuery. That can use ? substitution to avoid string conversion. Write the result dataset to the memory tag.

3 Likes