Custom Client Side filtering

[Andrei]

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).

[Georgi Krustev]

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

 

 

[Andrei]

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

[Andrei]

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???

[Georgi Krustev]

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

 

 

[Andrei]

Thank you Georgi, this is exactly what I was looking for!

[Arman]

Hello Georgi,

 

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

[Georgi Krustev]

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:

• http://dojo.telerik.com/eRoDO

Regards,
Georgi Krustev
Telerik