I can create a Query Tag that works fine and gets the results I would expect but if I try to run the exact same query using executeQuery in an expression I get "Invalid object name". I have tried with multiple queries and used different database connections.
By default I don't believe base Ignition has any expression functions that allow you to call a query outside of using runscript
. Can you show your expression/binding configuration?
I couldn't find any docs on executeQuery
but it does get syntax highlighting in the expression edit area. Maybe a deprecated expression function?
Found it, it was removed in v8.0.0. All the more reason to not use it on 8.1.x
3 Likes
Thanks for the help.