Named Queries binding with SQL Table Name


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:


Previously the following worked in Vision:

Could anyone please guide.

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

1 Like

Thanks @pascal.fragnoud. That was so simple. :exploding_head:

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

1 Like

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

1 Like