I am using an in-house query builder to generate prepared statements. The value of doing this is that maintenance is extremely simple, but I have some queries - such as getting a User table - which I run very frequently but for which the results never really change unless a User is added.
I can cache in each client with a decorator function, but each client still needs to make a call to the database once to initialize the DataSet. I would like to have the Ignition server query the query, cache the results, and then give clients access to this; however, I would like to do this on the fly in scripting.
It looks like NamedQueries are the only in-built tool in Ignition to handle this particular problem, but it seems you have to write each query in the designer.
Is there any way to create named queries through scripting at runtime?