Hello!
The filter in Kendo Grid works on data from the source, not the formatted data. For example in my data source I have columns with numbers between 0 and 1 like 0.5, 0.3 etc. Then I format that numbers to be percents - like 50%, 30% etc. Now if I want to filter that column and put "greater than" 20, I get no results because kendo filters by real data, not the representation.
How do I fix this? Is there a way to write some custom function for that? Please advise.
The filter in Kendo Grid works on data from the source, not the formatted data. For example in my data source I have columns with numbers between 0 and 1 like 0.5, 0.3 etc. Then I format that numbers to be percents - like 50%, 30% etc. Now if I want to filter that column and put "greater than" 20, I get no results because kendo filters by real data, not the representation.
How do I fix this? Is there a way to write some custom function for that? Please advise.
1 Answer, 1 is accepted
0
Hello Andrey,
Filtering is executed in the DataSource and is always against the actual data. The Grid only represents that data with some formatting eventually.
If you need filtering on formatted data it should be in the DataSource in first place.
Regards,Nikolay Rusev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!