Named queries for module developers

[Guest]

The 7.9.4 beta 1 is up as of today. The focus of this release is security, and one of the new features that can affect module developers is named queries.


Named queries are a way to define database queries in advance, so that clients can't run random queries. An added benefit is that queries become easy to reuse throughout your project.


As a module developer, here's what you need to know about named queries:


Clients may or may not have legacy db access enabled. If they don't, the client is restricted to only using named queries. Your module needs to handle this gracefully. (If legacy db access is disabled, things like tag history, transaction groups and alarm history will still work, because those queries are predefined.)
The API for report datasources has changed slightly. If you have written a custom datasource in your module, you can probably use null for the new argument.
If your module has a panel for authoring db queries, similar to the component binding panel in Vision, you will need to also accommodate named queries.




I didn't find the right solution from the Internet.


References:

https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524

3D Animation Agency Example

[AMK]

That's way over my head.

[Steve]

Huh??

.

[Sandy]

The 7.9.4 beta 1 is up as of today. The focus of this release is security, and one of the new features that can affect module developers is named queries.


Named queries are a way to define database queries in advance, so that clients can't run random queries. An added benefit is that queries become easy to reuse throughout your project.


As a module developer, here's what you need to know about named queries:


Clients may or may not have legacy db access enabled. If they don't, the client is restricted to only using named queries. Your module needs to handle this gracefully. (If legacy db access is disabled, things like tag history, transaction groups and alarm history will still work, because those queries are predefined.)
The API for report datasources has changed slightly. If you have written a custom datasource in your module, you can probably use null for the new argument.
If your module has a panel for authoring db queries, similar to the component binding panel in Vision, you will need to also accommodate named queries.




I didn't find the right solution from the Internet.


References:

https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524

3D Animation Agency Example

Maybe try a different forum. LOL.

[BigD_83]

First I was disappointed that Joe Clark wasn't a Canadian member...

second, "Joe Clark" has posted a few times about his BMW GS and hasn't clued in that this is a Suzuki site.


I'm voting spambot...

[eil]

Yup, spambot.

[Rijko]

seems a real life person ... and has human problems like some of us
http://www.thegsresources.com/_forum...m-laughing-now!!

[Steve]

"He" might have some human qualities, but all of his few posts have a line saying "I didn't find the right solution from the Internet.", then gives a link to a BMW forum.

His bike is a BMW R1200GS, he probably did a search for "GS forum" and found us.

He also has "USA" as his location, but talks about riding in the sand near his home in Australia.

.

[Rijko]

idk .. strange indeed.
Human or bot, this is a clear case of Freudian need to be converted
and belong to the right GS group so let's welcome this entity to our herd

[Sandy]

idk .. strange indeed.
Human or bot, this is a clear case of Freudian need to be converted
and belong to the right GS group so let's welcome this entity to our herd

I don't know, he sounds pretty dysfunctional. Oh wait ...he'll fit right in.

[AMK]

I'm going to give credit where credit is due...
This post was actually done by the genius Kathy Applebaum in anothe forum.
joeclark must be a wannabe.

Still over my head.

[bwringer]

[Redman]

Bot

Bot

Bot

BOT

BBOOOOOOOOTTT


(and I suggest not going to the links).