Submitted by jimspoon on 2018/08/21 20:39
After I loaded the first 1000 of 1800 items that met the grid filter criteria, I applied a column filter.  Then I saw that the column filter was applied only to the first 1000 loaded items, not to the 1800 total items that met the other filter criteria.  Items that would have been shown if the column filter were applied to all 1800 items were not shown when only the first 1000 items were loaded.
 
Now when 1800 items meet the other criteria, it's not a big deal to refresh the grid to load all items.  But I also tried to load about 50,000 items into a grid in order to apply a column filter, but IQ froze when I tried to load that many items.
 
Would it make sense to apply the column filter to all the items that meet the other filter criteria?  Otherwise I have to filter the grid using another method, rather than a column filter.
 
Also I wonder if you could add an IDIOT button to abort gracefully an attempt to load 50,000 items into a grid.   
 

Comments

The Column Filter by design doesnt work on what isn't loaded.
Let's see... from 2. Filtering --
Quote//
  • The filter can list all loaded items (default) or just visible items (i.e. collapsed sub-items are not shown). Hold the Shift key to limit the list to visible items
  • If Grid > Properties > Auto-Updates is checked (default), the grid will load all items and sub-items, even sub-items of collapsed items (up to 9 levels deep)
//Quote
The second line there sounds like it will always load all items to grids, which would not be what you want -- can you test this on the grid with 1800, as opposed to the grid with 50K items :D
 
I dont have any grids with thousands of items, but one way of filtering them before opening the grid would be to first apply a filter in the manage grids window. If you already have filter/s applied in the filter box (see Source Filter Editbox) you could extend it / write another bit to apply the equivalent of the column filter. That's where I fall down myself, never having learned how to write a filter properly. (I dont use them much -- tend to copy earlier versions or use ones shown in the manual page, and then modify them.)