# Dropdown vision

**URL:** <https://forum.inductiveautomation.com/t/dropdown-vision/37390>\
**Category:** Ignition\
**Created:** [August 4, 2020, 9:09pm UTC](https://forum.inductiveautomation.com/t/dropdown-vision/37390 "2020-08-04T21:09:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![malejandroreyes](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\
**Post date:** [August 4, 2020, 9:09pm UTC](https://forum.inductiveautomation.com/t/dropdown-vision/37390/1 "2020-08-04T21:09:43Z")

</div>

Hi

I´m using a dropdown list as data filter, but now I want to filtrate data making a comparison as \>, \< or equal, is this possible?

Thanks

---

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [August 5, 2020, 7:55am UTC](https://forum.inductiveautomation.com/t/dropdown-vision/37390/2 "2020-08-05T07:55:31Z")

</div>

> [@malejandroreyes](#):
>
> I´m using a dropdown list as data filter

of what ?  
How are you filtering now ( scripting, expression, SQL )?

---

<div class="post-metadata">

**Author:** ![malejandroreyes](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\
**Post date:** [August 5, 2020, 2:45pm UTC](https://forum.inductiveautomation.com/t/dropdown-vision/37390/3 "2020-08-05T14:45:10Z")

</div>

Hi

I´m filtering whit a named query, data type are floating point

---

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [August 5, 2020, 3:03pm UTC](https://forum.inductiveautomation.com/t/dropdown-vision/37390/4 "2020-08-05T15:03:31Z")

</div>

Well, I’m no expert on NamedQuery but I know it can be done with SQLQuery.  
You have just to create another dropdown with the = \> \< option and insert the dorpdown **selectedLabel** property inside the Query.  
Something like this:

```auto
SELECT [Value1]
FROM [YourTable]
WHERE [ValueX] {Root Container.Dropdown 1.selectedLabel} {Root Container.Dropdown.selectedValue}

```

The first dropdown is the = \> \<  
The second is you current dropdown.

Since I’ve never used NamedQuery I don’t know how to do it with them.  
Hope this will help you.

---

<div class="post-metadata">

**Author:** ![malejandroreyes](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\
**Post date:** [August 5, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/dropdown-vision/37390/5 "2020-08-05T15:07:05Z")

</div>

Thank you!