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
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
17 Answers, 1 is accepted
0
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
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
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0

Dennis
Top achievements
Rank 1
answered on 01 Jun 2012, 05:32 PM
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
Thanks, Dennis
0
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
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
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0

maharajan
Top achievements
Rank 1
answered on 20 Sep 2012, 05:25 AM
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
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
0

Jerry
Top achievements
Rank 1
answered on 25 Sep 2012, 10:05 PM
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!
0
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:
I hope this information will help.
Kind regards,
Alexander Valchev
the Telerik team
@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
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0

Sean
Top achievements
Rank 1
answered on 31 Dec 2012, 07:12 PM
Is it possible to set any of these values using MVC extensions?
0
Hi Sean,
Yes it is possible. Please see the documentation of GridFilterableSettingsBuilder.
Kind regards,
Alexander Valchev
the Telerik team
Yes it is possible. Please see the documentation of GridFilterableSettingsBuilder.
Kind regards,
Alexander Valchev
the Telerik team
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0

Steven
Top achievements
Rank 1
answered on 04 Jan 2013, 04:24 AM
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?
0

Jayesh Goyani
Top achievements
Rank 2
answered on 04 Jan 2013, 08:08 AM
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
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
0

Steven
Top achievements
Rank 1
answered on 04 Jan 2013, 05:37 PM
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.
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.
0

Jayesh Goyani
Top achievements
Rank 2
answered on 09 Jan 2013, 10:21 AM
Hello,
For toolbar filtering you have to add below JS as mentioned in Demo.

Thanks,
Jayesh Goyani
For toolbar filtering you have to add below JS as mentioned in Demo.
Thanks,
Jayesh Goyani
0
Hello guys,
In Kendo MVC wrappers you can set the filterable options for all columns per data type. Here is the syntax:
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.
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
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
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0

John
Top achievements
Rank 1
answered on 05 Feb 2013, 03:45 PM
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?)
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?)
0

John
Top achievements
Rank 1
answered on 06 Feb 2013, 03:34 PM
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)
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)
0
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
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
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0

Steven
Top achievements
Rank 1
answered on 21 Jul 2013, 05:54 PM
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"); })))