Change Default Operator

[Stefan]

We have a column of type text, and want to change the default filter from 'equals' to 'contains'.

This doesn't seem to have any effect: 

.Filterable(f => f.Cell(c => c.Operator("contains")))

This does not seem to work in the context of the MVC Grid: jQuery Set the Default Filter Operator in the Grid - Kendo UI for jQuery

[Eyup]

Hello Stefan,

 

Thank you for reaching out.

This will work when you have the following mode active:

 .Filterable(f=>f.Mode(GridFilterMode.Row))

Here is a live sample I have created for demonstration:
https://netcorerepl.telerik.com/mzvPELkN33xFlTg237

As an alternative, you can also try adding the .Clear() method:

columns.Bound(p => p.ColumnName)
    .Filterable(f => f.Operators(o => o
        .ForString(fs => fs.Clear() // Removes all other operators
            .Contains("Contains")   // Adds "Contains" as the default and only option
        )
    ));

Or, to keep more options with "Contains" as default:

columns.Bound(p => p.ColumnName)
    .Filterable(f => f.Operators(o => o
        .ForString(fs => fs.Clear()
            .Contains("Contains")
            .StartsWith("Starts with")
            .Eq("Equals")
        )
    ));

 

Let me know if you find this helpful or if you have further instructions.

 

Regards,
Eyup
Progress Telerik

[Stefan]

Hello Eyup,

thank you for the examples. Unfortunately we're not using the 'Row' filter mode.

When using the Clear() method, and subsequently adding the different filter options again, the options lose their automatic multi-language support. Do we have to provide the option labels for different languages ourselves then?

 

Kind regards.

[Anton Mironov]

Hi Stefan,

In order to achieve the desired behavior, I would recommend using the approach from the following article:

• https://www.telerik.com/kendo-jquery-ui/documentation/knowledge-base/grid-change-default-filter-operator

Here is a dojo example:

• https://dojo.telerik.com/RzUAAvNS

By using the FilterMenuInit Event, you can change the default operator as shown in the examples above and also to remove the unneeded ones.

 

Kind Regards,
Anton Mironov