Tags Broken when opened in client

Ignition
1

I am new to ignition and this is my first project. I have created a KPI Project where I am pulling data from an existing SQL on an existing gateway. I created a bunch of charts. Its working well in designer but when I open it in the client all the tags are broken.

2

By default, Vision client permissions are such that the client is not allowed to execute arbitrary database queries, because it's a big security hole.

Either:

  • Migrate your DB bindings to named queries (do this)
  • Enable the 'Legacy DB Access' Vision Client permission (don't do this)
1 Like
3

ok, I think I know how to convert to named queries. I will give that a try, thank you!

4

There's a button on the binding to do it for you:

image
image1642×1480 185 KB

1 Like
5

Yes, I got there but it is asking for a path!?

6

Named queries are a project level resource. You just need to decide the path where binding X gets stored as named query Y.

7

It appears to be looking for a unique identifier, just a name correct?

8

Yep. Maybe put them all in a folder called KPI and name each query (for each chart) according to what it is, e.g. KPI/Employee Metric A (or whatever).

1 Like
9

Ok, makes sense, thank you. I tried it on one chart and it worked, Much appreciated

1 Like