Can I reference the name of a query tag in the query?

Ignition Exchange
1

I want to create a set of query tags for different machines at my facility.
If I named the query tags, for example, "23" to represent that it's for machine 23, is there a way to reference the name "23" in the following scenario:

Select *
From query
Where machine = [Query Tag Name]

So that when I copy and duplicate the tag, it automatically updates without me having to go into each individual query tag to adjust this value?

2

Try,

SELECT *
FROM tableName
WHERE machine = {this.name}

I can't test it at the moment but it works in expression tags.

3

This is really bad for your database, unless the queries are parameterized, use event driven mode, and therefore only run occassionally.

If you need to run these regularly, use a timer or scheduled event. Its script would read all the machines in one query, split into subsets, and write the subsets to tags. Your database admin will appreciate it.