Named Queries binding with SQL Table Name

arsalan.junaid · July 5, 2023, 3:18am

Hi,

I am trying to link a variable (String) to the Table on a NamedQuery in Perspective Ignition 8.1.19 but it is not working.

My code:

Error:

Previously the following worked in Vision:

Could anyone please guide.
Thanks

pascal.fragnoud · July 5, 2023, 7:30am

You'll need to use a query string instead of a value variable for this.

arsalan.junaid · July 5, 2023, 7:45am

Thanks @pascal.fragnoud. That was so simple.

pturmel · July 5, 2023, 12:09pm

Be very careful, though. QueryString parameters are not secure, so you must not allow user-entered values in such parameters.

arsalan.junaid · July 5, 2023, 12:26pm

Sure @pturmel I am using it for predefined variables only.
Thanks for the warning btw.