.Hi
I’m using jqGrid 4.6.0 for sometime now and am very happy.
I decided to check out 4.8.2 for Pivots. This too, looks very nice but I’m stuck on changing the pivot JSON url.
for regular grids i just change the “url” with jqGrid(‘setGridParam’,{url:….
but for the pivot this does not seem to work.
Please advise.
Hello,
Thank you for the question.
It is needed to know that the colModel of the pivot is builded dynamically, because of this changing the data source is not so easy.
Tha coulmns depend on the data. The pivot get the data analyze it – build dynamically the colModel and reconstruct the source so that it is readed to the grid.
In order to do this you will need to store your initial pivot settings m, then unload the grid and call it again with the new url. Here ia code sniplet
|
1 2 3 4 5 6 7 8 9 10 |
var pivotoptions = {...}, gridoptions = {...}; jQuery("#jqGrid").jqGrid('jqPivot',"data.php", pivotoptions, gridoptions); // to call new data source $.jgrid.gridUnload("#jqGrid"); jQuery("#jqGrid").jqGrid('jqPivot',"newdata.php", pivotoptions, gridoptions); |
Hope this helps
Kind Regards
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
