Database Filter on PivotClient

[Miguel Jesús]

Is there any way to force that all filters do by database queries and not in server side?

I mean I want to use pivotclient control to filter a huge table (1 million rows or more) and working with the whole table is inefficient.

Could you give me some advices?

Regards,

[Manikandan Murugesan]

Hi Miguel, 

Thank you for contacting Syncfusion Support. 

Currently we don’t have provision to filter PivotGrid data through database queries. Meanwhile, we will consider this in any one of our future release. 

 

Thanks, 

Manikandan.