Can you force a query tag to execute?

Ignition
1

Hi!

I have a query tag like this:

SELECT
	ID
FROM
	TABLE
WHERE
	WORKCENTERID = {[.]ROOMID}
	AND PLANTID =  {[.]PLANTID}

We are in the test phase, and we are currently changing the id from the table (this will not happen in the future).

It's possible to force the tag query execution?
Would be better to execute this for every room every couple hours?

Note: the db id is unique across multiple plants, the roomid isn't.

2

Change the Execution Mode from Event Driven to Fixed Rate or Tag Group.
Change it back to Event Driven when your testing is done and the data is more static.

3

Two options. Option 1 is to make it a named query and use a gateway script, probably timer or scheduled, and write the results to the tag. This allows you to use the query in other places and be able to force the execution. The NQ also gives you one source of truth.

Option 2, create a special Tag Group for it and force the execution with system.tag.resquestGroupExecution