Hi
I am showing a list of people in an SfDataGrid. Each person has a list of children shown in a column as a comma separated list of names (some of the children have identical names).
The filter control by default shows the list of options as the combination of names (see DefaultFilterValues.png from the attached rar file). I am trying to change that so that it shows each unique name by itself instead (see PreferredFilterValues.png from the attached rar file), so I can search for persons that have a child with the selected name.
I can change the list of names in the filter control by handling the FilterItemsPopulated event and generate new FilterElements, but I have not been successful in making the subsequent filtering work (I tried handling the FilterChanged event and manipulate the filter predicates).
Hope you can assist.
Regards
Troels Pedersen
Attachment:
Screenshots_ed80199a.rar