GridViewDataColumn Filter and Contains

[Pavel]

Hi!
I have a filter with values ​​set (via DistinctValuesLoading). There is a string property in the elements. Is there a way to use "Contains" when filtering elements.

I used a CustomFilteringControl:

var ids = this.distinctValuesListBox.SelectedItems.OfType<string>();
this.filterDescriptor = new FilterDescriptor<RowInfo>()
{
    FilteringExpression = rowInfo => ids.Any(x => rowInfo.Name.Contains(x))
};
gridView.FilterDescriptors.Add(this.filterDescriptor);     

 

It works. But I can't use RadGridView settings saving. And for each column (in different tables) where such mechanics will be used (unique values ​​will be different) it will be necessary to create its own CustomFilteringControl and add it to ICustomPropertyProvider to save RadGridView settings.

 

Is there a way to set the filtering method to "Contains"?

Something like this:

DistinctValuesSearchMode="Contains"

[Martin Ivanov]

Hello Pavel,

There is no "Contains" option for the distinct values in the default FilteringControl. To achieve your requirement you should write custom logic, as you are already doing.

To save the settings of the custom filtering control you should write also custom persistence behavior.

I have prepared a small sample showing one way to implement a custom FilteringControl showing only distinct values and that can be used for different columns. The example shows also how to serialize these settings. I hope this helps.

Regards,
Martin Ivanov
Progress Telerik