jQuery Grid Plugin - jqGrid - Topic: ColumnChooser save to server http://www.trirand.com/blog/?page_id=393/discussion/columnchooser-save-to-server Simple:Press Version 5.7.5.3 csitol on ColumnChooser save to server http://www.trirand.com/blog/?page_id=393/discussion/columnchooser-save-to-server#p12549 Discussion http://www.trirand.com/blog/?page_id=393/discussion/columnchooser-save-to-server#p12549 This (sending the information back to the server) is very easy to accomplish.  There's a function available called "getGridParam" that takes the 'colModel' information from the JS setup (hopefully this makes sense).  This returns all of the information about the columns including which are hidden, the order, etc.  If you're using PHP you JSON.stringify the data you get back and then send it as an Ajax call to your PHP (or whatever) code.  Then you can decide where to keep it, etc.  If you need code for this and you're using PHP and MySQL I'd be more than happy to send you what I've done.

To my mind this is the best of both worlds; you get to decide how to store the data but it's easy to retrieve from jqGrid!

Also, to further what markw65 said, the DND option in the hide selection list is already there and works perfectly.

Regards,

PhilM

]]> Sat, 28 Nov 2009 06:58:33 +0200 markw65 on ColumnChooser save to server http://www.trirand.com/blog/?page_id=393/discussion/columnchooser-save-to-server#p12460 Discussion http://www.trirand.com/blog/?page_id=393/discussion/columnchooser-save-to-server#p12460

dpeterman said:

Any chance of adding a call back on “done” for the columnChooser? It would nice to be able to save the column configuration to the server.

Also, being able to order the columns would be fantastic. Instead of a list of columns you could have 2 lists. The left hand side would contain the hidden columns and the right hand side for the displayed columns. Then add some up/down arrows to the “display” list to re-order the columns (also drag n drop would nice).

There is a "done" callback, but its harder than necessary to intercept (basically, if you intercept it, you're responsible for calling reorderColumns). This should be fixed...

The default callback does this:

"done" : function(perm) { if (perm) this.jqGrid("remapColumns", perm, true) },

You can replace it with one that does that, and then whatever you want.

As for the re-ordering, and two lists - you described /exactly/ how it works today (except that the displayed items are on the left!).

Im guessing you need to include ui.muiltiselect.js (without that you'll just get a standard <select multiple> element)

Mark

]]> Wed, 25 Nov 2009 18:06:06 +0200 dpeterman on ColumnChooser save to server http://www.trirand.com/blog/?page_id=393/discussion/columnchooser-save-to-server#p12455 Discussion http://www.trirand.com/blog/?page_id=393/discussion/columnchooser-save-to-server#p12455 Tony,

Any chance of adding a call back on "done" for the columnChooser? It would nice to be able to save the column configuration to the server.

Also, being able to order the columns would be fantastic. Instead of a list of columns you could have 2 lists. The left hand side would contain the hidden columns and the right hand side for the displayed columns. Then add some up/down arrows to the "display" list to re-order the columns (also drag n drop would nice).

Love the tool--Doug

]]> Wed, 25 Nov 2009 16:41:35 +0200