Guriddo » Topic: PivotGrid Reload Example

PivotGrid Reload Example

Guriddo
pivotGrid PHP
PivotGrid Reload Example

Tagged: pivotGrid PHP

This topic has 6 replies, 2 voices, and was last updated 7 years, 4 months ago by ariadrianto.

Creator

Topic
August 26, 2017 at 10:33 am #126352

ariadrianto
Participant

How to reload pivotGrid PHP ?
I need to reload just like jqSuite PHP …

Any example of pivotGrid PHP to reload ?

Thanks
Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies
August 28, 2017 at 7:55 am #126353

guriddo.support
Participant

Hello,

Reloading of pivot is a little bit tricky – since we need to recalculate the columns again depending on the source data.

Simple – you need first to destroy the grid and then call pivot again – this all is with JavaScript:

function reloadPivot( grid, newdata, options ) { $.jgrid.gridDestroy( grid ); $("#grid").jqGrid('jqPivot', newdata, options); }

1
2
3
4
5

function reloadPivot( grid, newdata, options )
{
$.jgrid.gridDestroy( grid );
$("#grid").jqGrid('jqPivot', newdata, options);
}

Kind Regards,
Will

Guriddo Support Team

November 25, 2017 at 6:34 am #126442

ariadrianto
Participant

Hi…
i’ve tried but no luck…

Uncaught TypeError: Cannot read property ‘grid’ of undefined

is there any demo of this ?

Thank you

November 27, 2017 at 1:11 pm #126445

guriddo.support
Participant

Hello,

Sorry for the wrong command provided. Instead of destroy a unload function should be used – i.e replace

$.jgrid.gridDestroy( grid ); ...

1
2

$.jgrid.gridDestroy( grid );
...

with

$.jgrid.gridUnload( grid ); ...

1
2

$.jgrid.gridUnload( grid );
...

Below is a demo

Guriddo Support Team

December 2, 2017 at 8:12 am #126472

ariadrianto
Participant

Hi…

It’s working… Thank you

but… without summary column / colTotals …

December 2, 2017 at 8:02 pm #126473

guriddo.support
Participant

Hello,

colTotals are working fine, you will need to set them. Please look at the updated demo

Kind Regards,

Will

Guriddo Support Team

December 5, 2017 at 9:34 am #126476

ariadrianto
Participant

Hi,

Thank you very much… it’s worked now…
Author

Replies