Pivot Grid Dynamic Query

Question

HiI want to know that how can I use pivot grid with dynamic sql query?Thanks.

Manikandan Murugesan · Answer

Hi Olman, 
 
We were unable to understand the exact requirement from your query. Meanwhile, we have prepared prototype sample for refresh the PivotGrid dynamically. Please find the sample in below link. 
http://www.syncfusion.com/downloads/support/forum/135044/ze/PivotClientWEB_(4)-1683612199 
In the sample, we have dynamically change the datasource using button click event. Here, you can call AJAX method and get data from database and set it to the PivotGrid. Please refer below code snippet. 
Code Snippet: [javascript] 




function btnClick(args) { 
            var pivotGridObj = $('#PivotGrid1').data("ejPivotGrid"); 
            pivotGridObj.model.dataSource.data = data; 
//Here, you can call AJAX method and get data from database and set it to the PivotGrid. 
            pivotGridObj.refreshControl(); 
} 
 
If this doesn’t match your requirement, kindly provide more details about your requirement with screenshots/video (if possible) which would be helpful for us to proceed further. 
 
Thanks, Manikandan.