InfoQube IM - Community

Submitted by Jon on 2010/01/24 16:00

I know I know this, but I don't use it often enough. How do I filter on fields that are populated by pop up lists?

Thanks.

Jon

Comments

Hi Jon,

What do you mean exactly ? Sorry, I'm not sure I understand.

Are you asking :

1- how to filter what appears in fields' pop-up (in the grid) so that only certain values appear in the pop up (-- link to nonexistent node ID 294 --)

2- filter items in a grid depending on the fields' value ? (2. Filtering and -- link to nonexistent node ID 855 --)

[EDIT : Added some references]

Hi Armando:

I have pop-up fileds in one of my grids. Let's suppose the values are 1,2,3,4,5. I would like to show only those items associated with a value of 4. I want to set this up in another grid. So grid 1 might show this:

Item Field

First item 2

Second item 4

Third item 3

Fourth item 2

I would like to set up grid 2 to display only items relate to field 2

Item

First item

Fourth item

Thanks for your assistance

Jon

Ok, that's simple.

There are at least 2 ways of doing this, but use #2

1- you can use the column filters -- right click on column header > filter column, and type the value to filter data.

2- In the source bar, filter text box (the middle text box : see the 3rd screenshot on Items, Values and Views), write :

myfield = value

Where my field is your field name and value is your numeric value. However, if your field is not a numeric field you need to use that syntax instead :

myfield like "value"

You can use wildcards ( * ) to filter for the string wherever it is :

myfield like "*value*"

You can use Boolean operators to mix several filters/conditions

myfield like "*value1*" AND myfield like "*value 2*"

myfield = "*value1*" AND myfield = "*value 2*" OR (myfield like "*value1*" AND myfield like "*value 2*")

See Source Filter Editbox for further explanations

Note that the filter can be set to be applied to Top level items only, or to Top level items and sub items.

Grid (menu) --> Filter criteria applies to subitems

Ahh...

I forgot the quotes! I knew it was something stupid. Still, it would be really nice if Pierre could incorporate a filter builder. Something to start with would be Ecco's, although more robust.

Thank you for your help Armando.

Jon

That "filter builder" you mention is part of the road map -- Not sure if Pierre really had your "filter builder" in mind, but pretty close... ;)