Reducing filter options on grid

[Thomas]

Hi
As default, the filtering options of the Kendogrid are very comprehensive, which is good.
However, when using serverside filtering there is a lot of things to implement on the server to respond to all these options.

I would like omit "is not equal to", "Starts with" and "Ends with" operators - is this configurable?

Best regards
Thomas

[Alexander Valchev]

Hi Thomas,

Yes, those options are configurable. You could see the syntax in this code library project - if you do not want some type of filters to be available, just omit their definition.
I hope this helps.

All the best,
Alexander Valchev
the Telerik team

[Dennis]

Alex - I have a suggestion that I think would be really nice for grid filtering:  Allow the header to be a text box or dropdown (whatever is appropriate), similar to inline-editing controls used when editing grid rows, to define a simple filter mechanism that offers a simpler alternative to the popups that exist today.

Thanks, Dennis

[Alexander Valchev]

Hello Dennis,

To achieve this I suggest to work with the filter method of the dataSource, thus way you will be able to create a custom filtering that fits in your requirements. Actually we have an on-line example that demonstrates a similar scenario.

Greetings,
Alexander Valchev
the Telerik team

[maharajan]

Hi
 I am wondering about the Kendo GRID filtering.
 Does this GRID has filter style (similar to Telerik GRID) with inline filtering ?
Please advice me on this.
Regards
Maharajan.P

[Jerry]

I looked through the project posted for this thread, was definitely helpful in showing how to customize the set of operators used for filtering.  But this doesn't apply to those columns implementing the foreign key lookup technique, correct?  The list of operators in that case just defaults to "Is Equal To" and "Is Not Equal To."  Can you confirm?  I'd love to be able to just set it to "Is Equal To" for cases where we just have two items.  Thanks!

[Alexander Valchev]

Hello guys,

@maharajan
I am afraid that the requested functionality is not supported. To filter the grid you could use the build-in popup filter menu or a custom UI and the filter method of the DataSource. 

@Jerry
Yes, the list of filterable operators for a foreign key column contains only those two options. You can customize them through the configuration options. Here is the syntax:

filterable: {
    operators: {
        enums: {
            eq: "Is EQ text",
            neq: "In NEQ text"
        }
    },
    messages: {
        selectValue: "Option Label" //drop down option label
    }
},

I hope this information will help.

Kind regards,
Alexander Valchev
the Telerik team

[Sean]

Is it possible to set any of these values using  MVC extensions?

[Alexander Valchev]

Hi Sean,

Yes it is possible. Please see the documentation of GridFilterableSettingsBuilder.

Kind regards,
Alexander Valchev
the Telerik team

[Steven]

The documentation does not show any example on how to change / limit the operators for MVC. My intellisense only shows an option for bool in filterable. Can you please show an example?

[Jayesh Goyani]

Hello Steven,

As per Alexander's code snippet this setting applied to the grid Level.

You are trying to set this settings at Column Level that's why you faced this issue.

Thanks,
Jayesh Goyani

[Steven]

Thanks for the reply Jayesh, but Alexander's code doesn't help much because I am trying to achieve this through Razor / C# (KendoUI for MVC) and his snippet is javascript. Moreover I would like to set the operators for a specific column, a datetime column as you can see in screenshot. I looked at the example here and this also does not show the Razor code.

Per your advice I am now getting intelisense since I have it in the correct place and I am attempting to figure it out but I have only found options for changing the message and not for limiting which operators I want available for a given data type or field. Or maybe I am missing something obvious, any clarity would be helpful and a code sample would be very helpful.

[Jayesh Goyani]

Hello,

For toolbar filtering you have to add below JS as mentioned in Demo.





Thanks,
Jayesh Goyani

[Alexander Valchev]

Hello guys,

In Kendo MVC wrappers you can set the filterable options for all columns per data type. Here is the syntax:

.Filterable(filterable => {
    filterable.Operators(operators => {
        operators.ForString(strFilter => strFilter.Clear().IsEqualTo("custom eq text"));
    });
    filterable.Extra(false);
})

Setting per column level is not supported in wrappers.
@Steven: If you prefer to use the Razor syntax, what I can recommend is to set the operators for all date columns.

operators.ForDate(dateFilter => dateFilter.Clear().IsEqualTo("custom eq text"));

At this stage we do not have plans to provide an opportunity for setting the filterable options per column in MVC wrappers. Please accept my apology for the inconvenience.

Kind regards,
Alexander Valchev
the Telerik team

[John]

Hi Alexander,

This only seems to work for IsEqualTo

If I replace this to StartsWith or Contains it doesn't work as expected.
I would be happy if I could even have Contains as the default as this is surely the most used (can we do this?)

[John]

Bump

Hi Alexander,

This only seems to work for IsEqualTo

If I replace this to StartsWith or Contains it doesn't work as expected.
I would be happy if I could even have Contains as the default as this is surely the most used (can we do this?)

.Filterable(filterable => {
    filterable.Operators(operators => {
        operators.ForString(strFilter => strFilter.Clear().Contains("contains"));
    });
    filterable.Extra(false);
})

This still seems to be using IsEqual (i.e. it workd if you enter exactly what you're looking for)

[Alexander Valchev]

Hi John,

This sounds like a know issue which is already fixed. May I ask which KendoUI version you use?
If it is an outdated one, please download and update to the Q3 SP release (2012.3.1315) or latest internal build. I tested this with the Service Pack and got it working as expected.

Regards,
Alexander Valchev
the Telerik team

[Steven]

I've added the additional syntax (MVC Wrappers) for example in case anyone else needs to see how to add multiple custom search fields. An added note for beginners, these will display in the order you list them and ForString() part means that the filter is applied to all string type columns.

.Filterable(f => f.Operators(o => o.ForString(fs => { fs.Clear().Contains("Contains"); fs.DoesNotContain("Does not contain"); fs.IsEqualTo("Equal to"); fs.IsNotEqualTo("Not equal to"); fs.StartsWith("Starts with"); fs.EndsWith("Ends with"); })))