# Named query parameters

**URL:** <https://forum.inductiveautomation.com/t/named-query-parameters/23079>\
**Category:** Ignition\
**Tags:** namedqueries\
**Created:** [March 5, 2019, 10:32pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079 "2019-03-05T22:32:02Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![WChester](https://avatars.discourse-cdn.com/v4/letter/w/df788c/32.png) [@WChester](https://forum.inductiveautomation.com/u/WChester)\
**Post date:** [March 5, 2019, 10:32pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/1 "2019-03-05T22:32:02Z")

</div>

I created 4 named queries that used 4 columns(see picture)

 ![named%20query%20](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/db33656ca73a2e3f1b6f455a4fbe138f725f5138.png)  
The only difference between the queries was that I changed the selected column. I then created 4 text field and list box combinations with 4 custom parameters (related to the columns in the query) and then bound the data property of the list box to the named query using these properties. The problem I had was when I created the bindings and then moved to the next list box I found that when I opened the named query binding they were already populated with the previous bindings. If went ahead and changed them to reflect the properties on the selected list box it then switched the others over to those bindings. I did need these to be different as I wanted to be able to search by characters on any one of these fields.

---

<div class="post-metadata">

**Author:** ![WChester](https://avatars.discourse-cdn.com/v4/letter/w/df788c/32.png) [@WChester](https://forum.inductiveautomation.com/u/WChester)\
**Post date:** [March 6, 2019, 3:04pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/2 "2019-03-06T15:04:37Z")

</div>

The way I got around it was to change the names of the parameters in each query. It seems odd that you can’t have similar named parameters in separate queries

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 6, 2019, 3:19pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/3 "2019-03-06T15:19:21Z")

</div>

What version are you using? This sounds vaguely like a bug that we fixed…

---

<div class="post-metadata">

**Author:** ![WChester](https://avatars.discourse-cdn.com/v4/letter/w/df788c/32.png) [@WChester](https://forum.inductiveautomation.com/u/WChester)\
**Post date:** [March 6, 2019, 3:30pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/4 "2019-03-06T15:30:41Z")

</div>

I’m using 7.9.8 to do this.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 6, 2019, 3:53pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/5 "2019-03-06T15:53:26Z")

</div>

Yikes, I was able to replicate this in 7.9.9. Looks like a regression to me – I’ll make a ticket to get this fixed. 😳

---

<div class="post-metadata">

**Author:** ![WChester](https://avatars.discourse-cdn.com/v4/letter/w/df788c/32.png) [@WChester](https://forum.inductiveautomation.com/u/WChester)\
**Post date:** [March 6, 2019, 3:56pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/6 "2019-03-06T15:56:45Z")

</div>

Ok Thank you for letting me know it was driving me a little crazy yesterday.

---

<div class="post-metadata">

**Author:** ![uTewell](https://avatars.discourse-cdn.com/v4/letter/u/e274bd/32.png) [@uTewell](https://forum.inductiveautomation.com/u/uTewell)\
**Post date:** [August 18, 2020, 7:47pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/7 "2020-08-18T19:47:07Z")

</div>

I am having this same issue. Has this been fixed?

I am using V7.9.8

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [August 18, 2020, 10:46pm UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/8 "2020-08-18T22:46:12Z")

</div>

Yes. You are using a version from before the fix.

---

<div class="post-metadata">

**Author:** ![uTewell](https://avatars.discourse-cdn.com/v4/letter/u/e274bd/32.png) [@uTewell](https://forum.inductiveautomation.com/u/uTewell)\
**Post date:** [August 19, 2020, 11:56am UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079/9 "2020-08-19T11:56:57Z")

</div>

What version was it fixed in?
