How to change default filter opertor for Distinct Values in RadGridView Filtering WPF

[Dilipkumar]

Dear Telerik Team,

I'm using Radgridview's Distinct values with my customized list, I'm using ServerSideFiltering and I've got the required outputs in my list but when I choose one of them the default filter operator is "ISEQUALTO" I'm trying to change it as Contains but it doesn't work help me with this

example
in my distinct values Filter:

APPLE
ORANGE
BANANA

in my column:
APPLE
APPLE,BANANA
APPLE,BANANA,ORANGE
BANANA

when I choose APPLE, it should return first 3 options in my column

When i choose APPLE and BANANA it should return all of them

Help me with this.

[Martin Ivanov]

Hello Dilipkumar,

As its name implies. the distinct values filtering works only with the IsEqualTo operator in order to show only distinct values. Changing the operator to Contains or another one will result in a different type of filter. There is no mechanism to change the behavior of the distinct filter, neither a direct API to add custom filtering UI.

However, you can still achieve your requirement by creating a custom FilteringControl or extending the default one. This will allow you to add custom UI that lists all of your distinct values. Then, you can implement custom filtering using the contains-based logic.

I've attached a small sample showing how to do this in the context of creating a new filtering control from scratch. I hope this helps.

Regards,
Martin Ivanov
Progress Telerik