.Hello, I have a few questions regarding exporting data. I am using Guridddo PHP Suite. In my SelectCommand I am using SELECT * to get all fields from the database because I want to be able to show them on the edit dialog. However in the main grid its way too many columns so I hide most of them with setColProperty.
My problem is when I export Data to CSV or Excel, jqgrid is not exporting all the data as I defined with ExportCommand, instead its exporting only the visible data in the grid (IE: Columns that are NOT hidden with setColProperty.
My questions are:
Thank-you.
Hello,
Thank you for the questions.
Now from the beginning.
Shortly – if the length of colModel in select command does not equal to the column data record set either from select or export command we use the native names from recorde set.
It seems that in your case you use the the select and export command have the same length (fields)
Only in this case the hidden property is used in export command
The possible solution to your questions is:
Use only SelectCommand with all fields needed for the grid and export.
For the normal grid use setColProperty to hide desired fields and set the labels for the headers.
Now after the last setting of setColPropery do
|
1 2 3 4 5 6 7 |
if($gird->oper == 'excel || $grid->oper == 'csv') { $grid->setCoProperty("Myfield", array("hidden"=>false, "label"=>"Mylabel")); // do this for other fields that are hidden and you want to show them ... } |
Hope you understand the point.
Please let us know if you have resolved your requierments.
Kind Regards,
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
