# Tags Broken when opened in client

**URL:** <https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378>\
**Category:** Ignition\
**Created:** [December 20, 2023, 3:53pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378 "2023-12-20T15:53:51Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\
**Post date:** [December 20, 2023, 3:53pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/1 "2023-12-20T15:53:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 20, 2023, 4:09pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/2 "2023-12-20T16:09:17Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\
**Post date:** [December 20, 2023, 4:10pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/3 "2023-12-20T16:10:32Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 20, 2023, 4:12pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/4 "2023-12-20T16:12:29Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b13ff4625fefe76b4e67e448f02e25b44f3a2c2.jpeg)

---

<div class="post-metadata">

**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\
**Post date:** [December 20, 2023, 4:13pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/5 "2023-12-20T16:13:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 20, 2023, 4:14pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/6 "2023-12-20T16:14:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\
**Post date:** [December 20, 2023, 4:14pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/7 "2023-12-20T16:14:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 20, 2023, 4:16pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/8 "2023-12-20T16:16:07Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\
**Post date:** [December 20, 2023, 4:17pm UTC](https://forum.inductiveautomation.com/t/tags-broken-when-opened-in-client/83378/9 "2023-12-20T16:17:19Z")

</div>

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