Submitted by WayneK on 2016/11/20 15:22
1) Column Filter is set to:
 
2) Outline is collapsed to Level 1
 
3) I filter (Ctrl-G) for the word "drive" that occurs only in subitems
 
4) Filter fails to find any of the subitems containing "drive" (displays blank grid).
 
5) I expand the outline to show all subitems
 
6) Now the filter works correctly and displays all subitems containing "drive".
 
7) I collapse the outline to Level 1.  This time the filter DOES find the subitems.
 
In summary, the filter fails to find relevant subitems unless outline is expanded.  Once it does find the subitems, it starts working correctly and will find the subitems even when the outline is collapsed.  The above does not occur every time but has cropped up at least a dozen times over the past few days.  I have screen captures for each of the above steps, if that would help.
 
Bonus question:  I don't understand the third option "Filter Out Sub-items".  Is it supposed to mean that it will ONLY filter sub-items?  If so, I couldn't get it to work that way.  In fact, I couldn't select this option without also turning on "FIlter Items at any levels".
 
Wayne
9.86b
 
 

Comments

I always thought the idea of filter (in any app) is to filter what is showing.
If that's the case, it would be correct that sub-items would *not* be shown -- unless displayed before the filter is applied. (I guess it's inconsistent then if they shown when items are collapsed again?)
 
I havent used those filter options so can comment further.

WayneK

2016/11/20 16:35

In reply to by Tom

Yeah, I first thought that that was just the way its supposed to work, which would be fine.  Except most of the time it does display the subitems.
 
 
Wayne
 

A couple of issues here:
  1. Grid column filter act on loaded items. If the sub-items aren't loaded, they won't be found. This is by design. You can expand all if you want to be sure to find it. I tend to use the Omnibox search a lot, more so than column filters
  2. Checkout the tool-tip on the Filter Out Sub-items. I think it is quite clear  (Should sub-items of a filtered item be shown or not)
  3. I had no problem selecting or unselecting this "sub-item" option
HTH !
 
Pierre_Admin
IQ Designer
 

Armando

2016/11/20 18:11

In reply to by Pierre_Admin

 
And there's also the possibility to use the source bar : filter text box.
 
-
IQ geek
Windows 8.1
CPU: Intel i5 2.6ghz

WayneK

2016/11/20 18:22

In reply to by Armando

Test #1 = Column filter set to "Filter First Level Items Only"; filter for word "test"
 
 
Expectation: filter will display only TLI's containing the word "test".  SLI's containing "test" will not be shown.
Test result: filter displays both TLI's and SLI's containing "test".
Comment: filter does not work as I expected.
 
 
 
 
Wayne
 

WayneK

2016/11/20 18:28

In reply to by Armando

Test #2 = Column filter set to "Filter Items at any level"; filter for word "test"
 
Expectation: filter will display all items containing the word "test" (both TLI's and SLI's)
Test result: filter displays both TLI's and SLI's containing "test".
Comment: filter works as expected but note that the results are identical to Test #1
 
 
Wayne
 

WayneK

2016/11/20 18:34

In reply to by Armando

Test #3 = Column filter set to "Filter items at any level" and "Filter out sub-items"; filter for word "test"
 
 
Expectation: filter will display only TLI's containing the word "test"?  I find this setting confusing.  How is this any different than just selecting "Filter First Level Items Only"?
Test result: filter displays both TLI's and SLI's containing "test".
Comment: filter does not work as I expected.  Why is it displaying "test3" when it's a sub-item"
 
Bigger question: why have all three tests so far given identical results?  What am I doing wrong?
 
 
 
Wayne
 

WayneK

2016/11/20 18:37

In reply to by Armando

Test #4 = Column filter set to "Filter First Level Items Only" and "Filter Out Sub-items"; filter for word "test
 
 
Expectation: filter will display only TLI's containing the word "test".  SLI's containing "test" will not be shown.
Test result: filter displays both TLI's and SLI's containing "test".
Comment: filter does not work as I expected.
 
Note: all 4 tests have given identical results.
 
 
 
 
Wayne
 

WayneK

2016/11/20 18:24

In reply to by Pierre_Admin

 
1) Had no idea about "loading" affecting the result.  This should be put in the help file.  If it's there, I missed it.
 
2) I'm probably just dense but I'm not finding it clear.  I'll post my testing and I'd appreciate being shown where I'm going wrong.
 
Wayne
 
Edit: tests are above

Pierre_Admin

2016/11/20 18:25

In reply to by WayneK

Consider this case:
  • A
  • B
    • C
    • D
  • E
  • F
 
If I filter for "B", you'll see Item B (not A, E and F). The question is: do you want to see C and D, or not ?
 
Pierre_Admin
IQ Designer
 

Pierre_Admin

2016/11/20 19:34

In reply to by Pierre_Admin

Hi Wayne,
 
Thanks for your 4 posts with samples.
 
Checkout my previous post however. I just tested, and everything is working as expected
The filter out sub-items is much simpler than what you expected
 
Pierre_Admin
IQ Designer
 

WayneK

2016/11/20 20:52

In reply to by Pierre_Admin

Pierre,
 
I'll work through it again.  I see I left out one other situation: target word is a TLI with a non-target SLI.  It just seems like it's set up in a confusing way or I'm inherently confused (I fear the latter).
 
Wayne