# Vision dropdown list occasionally displaying the int instead of the string column

**URL:** <https://forum.inductiveautomation.com/t/vision-dropdown-list-occasionally-displaying-the-int-instead-of-the-string-column/55056>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [January 15, 2022, 7:01pm UTC](https://forum.inductiveautomation.com/t/vision-dropdown-list-occasionally-displaying-the-int-instead-of-the-string-column/55056 "2022-01-15T19:01:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![philip](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/philip/32/5709_2.png) [@philip](https://forum.inductiveautomation.com/u/philip)\
**Post date:** [January 15, 2022, 7:01pm UTC](https://forum.inductiveautomation.com/t/vision-dropdown-list-occasionally-displaying-the-int-instead-of-the-string-column/55056/1 "2022-01-15T19:01:20Z")

</div>

Ignition 8.1.9

I have a dropdown list on a template that is displayed in a template repeater. This dropdown is bound to a named query that returns two columns, and integer and a string. The Selected Value of the dropdown is bound to a custom internal property of the template that has an indirect binding to a tag whose path is the templates only parameter.

Most of the time everything works as expected:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/2/f2618ca35a6d647b9d0d0d026f1e02e857769bad.png)

However occasionally the dropdown displays the integer value instead of the string value of the selected item:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/c/7cb3e9de077eb01d41ac129c0b482507953def05.png)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/0/90f74f2418be226e05e2995cb2ebc795784af2af.png)

The named query data binding is set to not poll and not retain rows. The named query binding has a parameter value that is bound to a client tag. When this client tag changes it causes the repeater on the window to reload with which also loads the templates with new tag path parameters. The dropdown dataset naturally reloads at this time as well and this is when the behavior seems to appear often. The values in the dropdown list are the correct values, so the dataset is being loaded correctly.

I’m thinking that there is a binding order issue or something going on. Am I doing something wrong? Anyone know a work around for this?

---

<div class="post-metadata">

**Author:** ![Ben.Mehmet](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@Ben.Mehmet](https://forum.inductiveautomation.com/u/Ben.Mehmet)\
**Post date:** [October 18, 2022, 1:28am UTC](https://forum.inductiveautomation.com/t/vision-dropdown-list-occasionally-displaying-the-int-instead-of-the-string-column/55056/2 "2022-10-18T01:28:17Z")

</div>

Hi Phillip,  
I am still having this issue (using version 8.1.20), did you find any work arounds for this ?  
Thanks,

---

<div class="post-metadata">

**Author:** ![philip](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/philip/32/5709_2.png) [@philip](https://forum.inductiveautomation.com/u/philip)\
**Post date:** [October 18, 2022, 4:39pm UTC](https://forum.inductiveautomation.com/t/vision-dropdown-list-occasionally-displaying-the-int-instead-of-the-string-column/55056/3 "2022-10-18T16:39:33Z")

</div>

Maybe - I don't recall what I changed, but looking at the project, the only thing that I see that is different from what I listed above is that I have the Selected Value binding set to an indirect tag instead of to a property on the template.

This is the only thing that is different now:

> [@philip](#):
>
> The Selected Value of the dropdown is bound to a custom internal property of the template that has an indirect binding to a tag whose path is the templates only parameter.