Filter GridView Column

[Pierre]

Hi,

I have a problem with the GridViews's standard filter. I use the filter setting "contains".
Here is the entire search string: "Pinset Borussia, Wappen, Figur"

If I type in Pinset Borussia the item is found. 
If I type in Pinset Wappen, the item cannot be found, although I used the filter option "contains".

Do you have a soloution to this problem?

Thank you and sorry for my English :).

Pierre

[Pierre]

Sorry, I don't know if you could understand my problem.
For better understanding I created two screenshot to show you this example.

What can I do that the filter in Example2 find the Item?

Thank you.

Pierre

[George]

Hi Pierre,

Thank you for writing.

When filtering and the filter is "Contains" the rows are filtered only by the value in the textbox, they are not filtered by each word. Which means that the behavior you are getting is expected. You can, however implement such functionality by yourself by using CompositeFilterDescriptors. You can subscribe to the FilterChanged event of RadGridView and split the values so that you can create a separate descriptor for each word:

private void Grid_FilterChanged(object sender, GridViewCollectionChangedEventArgs e)
{
    if (e.NewItems == null || e.NewItems.Count == 0 || e.NewItems[0] is CompositeFilterDescriptor)
    {
        return;
    }

    FilterDescriptor desc = e.NewItems[0] as FilterDescriptor;
    if (desc != null && desc.Operator == FilterOperator.Contains)
    {
        this.Grid.FilterDescriptors.Clear();
        string[] values = (desc.Value as string).Split();
        CompositeFilterDescriptor compositeDescriptor = new CompositeFilterDescriptor();
        compositeDescriptor.LogicalOperator = FilterLogicalOperator.Or;
        for (int i = 0; i < values.Length; i++)
        {
            FilterDescriptor newDescriptor = new FilterDescriptor(desc.PropertyName, desc.Operator, values[i]);
            compositeDescriptor.FilterDescriptors.Add(newDescriptor);
        }

        this.Grid.FilterDescriptors.Add(compositeDescriptor);
    }
}

Feel free to modify this example according to your needs.

I hope this helps.

Regards,
George
Telerik

 

 

[Pierre]

Hi George,

thank you! Your answer works fine for me. 
In my situation. I only changed a small detail. I changed the operator Or to And.

compositeDescriptor.LogicalOperator = FilterLogicalOperator.And;

Great support.

Regards
Pierre