Custom Client Side filtering

8 posts, 1 answers
  1. Andrei
    Andrei avatar
    10 posts
    Member since:
    Jul 2012

    Posted 26 Feb 2015 Link to this post

    Hi All,

    Does PivotGrid supports custom client-side filtering?
    I see PivotConfigurator has powerful filtering functionality however I need to make my own filters applied to the Pivot Data.
    Is there any API I can use to create my own filtering drop-downs or default filtering criteria.

    I guess PivotGrid and PivotConfigurator has this functionality, but is it available for client scripts?

    Thank you,
    Andrei

    P.S. I'm creating a POC to evaluate different vendors of pivot controls for ASP.Net MVC (Webforms is also an option).
  2. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3707 posts

    Posted 27 Feb 2015 Link to this post

    Hello Andrei,

    Currently, Kendo UI PivotGrid does not support client filtering when widget is bound to a flat data (FAQ here). This functionality is in our TODO list, but I cannot provide any specific time frame for its implementation, as there are tasks with higher priority.

    Regards,
    Georgi Krustev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET MVC is VS 2017 Ready
  4. Andrei
    Andrei avatar
    10 posts
    Member since:
    Jul 2012

    Posted 02 Mar 2015 in reply to Georgi Krustev Link to this post

    Hello Georgi,

    I connect to SSAS cube so the filtering works for me (I tried it via PivotConfigurator control).
    I'm wondering if I can access filter API of the grid via JavaScript code.

    Thank you,
    Andrei
  5. Andrei
    Andrei avatar
    10 posts
    Member since:
    Jul 2012

    Posted 03 Mar 2015 Link to this post

    Pfff, it is a premium support forum, isn't it?

    The idea is very simple. Users want to see data for a specific year only (current or latest). This can be achieved by built-in filtering functionality: Click on a row/column -> Include Fields.. -> choose year.
    But, this is annoying to enter the year each time you want to see data.
    So, I want to be able to set this filter in Pivot's config or via javascript.

    Is it possible???
  6. Answer
    Georgi Krustev
    Admin
    Georgi Krustev avatar
    3707 posts

    Posted 04 Mar 2015 Link to this post

    Hello Andrei,

    The guaranteed response time in premium forums is 48 hours (Mon-Fri). That being said, this ticket is still in those 48 hours range.

    With regards to the question, you can use the DataSource API and more specifically the filter method. I would suggest you check this "how-to" demo, which shows how to filter the widget initially. You can use the same filter format to filter the widget dynamically.

    Regards,
    Georgi Krustev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  7. Andrei
    Andrei avatar
    10 posts
    Member since:
    Jul 2012

    Posted 04 Mar 2015 in reply to Georgi Krustev Link to this post

    Thank you Georgi, this is exactly what I was looking for!
  8. Ola
    Ola avatar
    1 posts
    Member since:
    Nov 2012

    Posted 05 Nov 2015 in reply to Georgi Krustev Link to this post

    Hello Georgi,

     

    I see your last post was in February, hows the TODO list coming along?

  9. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3707 posts

    Posted 09 Nov 2015 Link to this post

    Hello Ola,

    The client filtering was added to Q3 2015 release of Kendo UI / UI for ASP.NET MVC. That being said, if the 2015.3.930 or newer version is used, then you can utilize the client filtering without a problem. Check this demo that shows how to enable filtering:
    Regards,
    Georgi Krustev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
UI for ASP.NET MVC is VS 2017 Ready