Dropdown vision

Ignition
1

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

2

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

3

Hi

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

4

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:

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.

5

Thank you!