@KathyApplebaum, have you an ETA for the 7.9.5 first beta ?
That’s a popular question today. 
Hopefully within a week, if all goes well.
Named Queries are a real time saver and a great addition to the product.
Any thoughts of adding the ability to use a named query in a SQL Query tag type in UDTs?
We’ve added named query client tags in 7.9.6. We’ll finish up the tag work (regular SQL named query tags and global named query resources which can be used across projects) in Ignition 8.0.
In the mean time, you have to do a bit of a work around – an expression tag which uses a runScript to get the results of the named query. :\
1 Like
Thanks Kathy… I thought about that for a work around too but I can wait for 8…
1 Like
Did a clear cache command get added?
I’m running 7.9.5 but am not finding any commands to clear the cache and request fresh results.
Clearing the named query cache was added in two scripting functions in 7.9.6:
https://docs.inductiveautomation.com/display/DOC79/New+in+this+Version
2 Likes
What about adding database transaction support (tx optional argument, using the result of system.db.beginTransaction) to system.db.runNamedQuery, as same as other system.db.run**** functions?
It’s high on our list, but most of our devs are working on 8.0 right now, so we haven’t gotten to that one yet.