This is Ignition version 8.1.33.
I've got a transaction group that has run-always expression to retrieve data from a database table in order to be able to do a calculation in the trigger portion.
If I do the expression as a SQL Query the value executes properly. However, if I use a Named Query it doesn't evaluate. Even if I remove all the parameters etc... and just execute the exact same SQL Query in both instances.
For reference this is the query
SELECT ts.val
FROM tblscale ts
LEFT JOIN tblconfigscale c on ts.sclid = c.id
WHERE c.tagpath = '[Development]Motors/FVNR/C100/SCL100'
ORDER BY ts.t_stamp desc
LIMIT 1
This is how I have the transaction group configured
I've tried a Named Query in a Parent project as well as the project that the Transaction Group is in, neither worked.
The only error message I get in the gateway logger and the transaction group window is: "Item 'dbSclLastVal' is not configured correctly. A tag executor could not be created for the item." with no further information.
Are there other loggers I can enable to further investigate this? Is this a bug? This is going to be a transaction group that will be duplicated multiple times and just the main tag path changed, so we would like to keep with a named query.
