Filtering by formatted data

2 posts, 0 answers
  1. Andrey
    Andrey avatar
    9 posts
    Member since:
    Apr 2016

    Posted 10 May 2016 Link to this post

    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.
  2. Nikolay Rusev
    Nikolay Rusev avatar
    2289 posts

    Posted 12 May 2016 Link to this post

    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.

    Nikolay Rusev
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top