I have a grid in which I've implemented a custom multi select combo box column which inherits from GridViewComboBoxColumn. The row data for the grid is a business object which contains a list of values which are then mapped as individual column in the grid (satisfying the customer need to be able to create their own fields). The underlying data for my ComboBoxColumn is a list of values. I've implemented a multi-select dropdown which allows the user to select multiple values via checkboxes. The Value property is overridden to show the values in the list as a simple string. The image below shows this:
What I now want to be able do is to filter on the values. "Show me the rows there 'WILSON' appears". Sounds too easy...
The filter options available are No Filter, Null, Not Null and Custom.
When I bash together a test project with a ComboBoxColumn I get the full
suite of filters. What happened to them for my custom column?
If there was the 'Contains' filter option that I hoped for I'm not sure that it will work properly anyway. The underlying data is a list, not a single value, so I'm not sure how the filtering would be applied.
I tried using the Excel filtering type (by implementing IGridFilterPopup
) but I encountered some errors relating to comparing elements in the list.
I was hoping for some advice/tips on the best way to implement this kind of filter?