Submitted by Ivo on 2017/11/23 10:26
For a Yes/No column, how do I filter out all checked items and their sub-items? I want to show only unchecked items whose parents and ancestors are unchecked in that attribute.
 
When I try using the menu from the top of the column to choose "Unchecked", the checked item and its sub-items are still visible. I have tried Grid>>Column Filter>>Filter Out Sub-Items, but this seems to make no difference.

Comments

 
The settings you want is:
 
It does not do what you want ?
 
[edit] Looking further into it, there is a small issue with background load which did not re-apply the filter when done. For now, first expand your hierarchy and then apply the filter, to see if it does what you want [/edit]
 
Pierre_Admin
IQ Designer
 

Ivo

2017/11/24 03:44

Permalink

I've tried that setting, and it doesn't do what I want. By the way, the display mode is set to "Outline (Normal)".

Pierre_Admin

2017/11/24 11:05

Permalink

Checkout v105b to see if it does what you want and report back with a screenshot or two if it doesn't
 
Pierre_Admin
IQ Designer
 

You can also achieve that using the filter textbox of the source bar (it's the middle textbox : see 2. Filtering : 6. Advanced filters using the Source bar  OR more specifically Source Filter Editbox)
(Alt+S to show the source bar – if that's still the default shortcut)
 
Let's say your field is named "check", just write :
 
check is null
 
And make sure that the filter applies to items AND sub items (click on the button at the left of the text box to select that)
 
and refresh.
 
 
Alternatively you can write :
 
check is null | check is null
 
and then you don't need to specify that the filter applies to items and  subitems
 
| = separates the top level item filter from the sub item filter.