We have a grid with a column that contains values that are the same except for case, e.g.,
In our grid, this column has a select filter which contains a drop down list element for each of the case sensitive elements. However, since the filtering is case insensitive, selecting any of those elements returns the matching rows for all of them. We like the case insensitive filtering and would like to prune the filter list so that only a lower case version of each value appears in the drop down list. I’ve tried to modify the list in the “onCollectValues” callback, but at that time, the filter element returned by getFilterElement has not been populated, so I don’t have any source values to work with. Is there a way to achieve the filtering of elements in the drop down list after the values have been collected?
Thanks for your consideration.