EJ2 PivotGrid: How do you execute a query on the grid?

[Mark]

Hello and this is probably a basic question, with the regular grid component, I can do query: new ej.data.Query().where(....) but I do not see that with the PivotGrid.  How do you go about doing dynamic queries for remote datasources with this component?

Thank you all!

[Manikandan Murugesan]

Hi Mark, 

Kindly refer the following code example to use your own query to fetch data in DataManager used in the pivot table. 

Code Example: 

var remoteData = new ej.data.DataManager({ 

    url: 'https://js.syncfusion.com/demos/ejServices/Wcf/Northwind.svc/Orders', 

    adaptor: new ej.data.ODataAdaptor(), 

    crossDomain: true 

  }); 

  remoteData.defaultQuery = new ej.data.Query().take(10); 

 

 

Meanwhile, we have prepared sample for your reference. 

Sample: https://stackblitz.com/edit/pfnzrw?file=index.js 

Please let us know if you have any concerns. 

Regards, 

Manikandan 

[Mark]

Thank you!  Worked like a champ!

[Manikandan Murugesan]

Hi Mark, 

Please let us know if you have any other queries. We are always happy to assist you. 

 

Thanks, 

Manikandan.