jQuery Grid Plugin – jqGrid

Post edited 15:03 – 18/07/2012 by Panciom

Hi to all and thank you for this great piece of code.

I'm trying to make a search page with the possibility to save parameters to recall the search later.

I use the following code to show the problem:

    var grid_conf=jQuery("#find").jqGrid('jqGridExport',{exptype:"jsonstring"});

    jQuery("#find").jqGrid('GridUnload');
    
    jQuery("#find").jqGrid('jqGridImport',{
        imptype: 'jsonstring',
        impstring: grid_conf
    }).trigger("reloadGrid");
}

When there are filter data (toolbar with stringResult:true or dialog search) the import fail with this error (from firefox console):

Data e ora: 18/07/2012 14.02.58
Errore: invalid property id
File sorgente: https://blahblahblah/lib_js/jquery.jqGrid.min.js
Riga: 30, Colonna: 372
Codice sorgente:
}, "beforeRequest":null, "beforeProcessing":null, "onHeaderClick":null, "viewrecords":true, "loadonce":false, "multiselect":false, "multikey":false, "editurl":null, "search":true, "caption":"Ricerca estesa consegne", "hidegrid":true, "hiddengrid":false, "postData":{ "_search":true, "nd":1342612973670, "rows":20, "page":1, "sidx":"delivery_id", "sord":"desc", "filters":{"groupOp":"AND","rules":[{"field":"delivery_id","op":"eq","data":"121"}]}, "searchField":"", "searchString":"", "searchOper":"" }, "userData":{ "success":true, "session_timeout":false, "message":"" }, "treeGrid":false, "treeGridModel":"nested", "treeReader":{}, "treeANode":-1, "ExpandColumn":null, "tree_root_level":0, "prmNames":{ "page":"page", "rows":"rows", "sort":"sidx", "order":"sord", "search":"_search", "nd":"nd", "id":"id", "oper":"oper", "editoper":"edit", "addoper":"add", "deloper":"del", "subgridid":"id", "npage":null, "totalrows":"totalrows" }, "forceFit":false, "gridstate":"visible", "cellEdit":false, "cellsubmit":"remote", "nv":0, "loadui":"enable", "toolbar":[ false, "" ], "scroll":false, "multiboxonly":false, "deselectAfterSort":true, "scrollrows":false, "autowidth":true, "scrollOffset":18, "cellLayout":5, "subGridWidth":20, "multiselectWidth":20, "gridview":false, "rownumWidth":25, "rownumbers":false, "pagerpos":"center", "recordpos":"right", "footerrow":false, "userDataOnFooter":false, "hoverrows":true, "altclass":"ui-priority-secondary", "viewsortcols":[ false, "vertical", true ], "resizeclass":"", "autoencode":false, "remapColumns":[], "ajaxGridOptions":{}, "direction":"ltr", "toppager":false, "headertitles":false, "scrollTimeout":40, "data":[], "_index":{}, "grouping":false, "groupingView":{ "groupField":[], "groupOrder":[], "groupText":[], "groupColumnShow":[], "groupSummary":[], "showSummaryOnHide":false, "sortitems":[], "sortnames":[], "summary":[], "summaryval":[], "plusicon":"ui-icon-circlesmall-plus", "minusicon":"ui-icon-circlesmall-minus" }, "ignoreCase":true, "cmTemplate":{}, "idPrefix":"", "recordtext":"Visualizzati {0} - {1} di {2}", "emptyrecords":"Nessun record da visualizzare", "loadtext":"Caricamento...", "pgtext":"Pagina {0} di {1}", "sortable":true, "useProp":true, "id":"find", "keyIndex":false, "localReader":{ "root":"rows", "page":"page", "total":"total", "records":"records", "repeatitems":false, "cell":"cell", "id":"id", "userdata":"userdata", "subgrid":{ "root":"rows", "repeatitems":true, "cell":"cell" } }, "width":1648, "tblwidth":1648, "disableClick":false, "_nvtd":[ 686, 20 ], "totaltime":54, "knv":null }})


Otherwise everything work as expected.

Notice that jsonstring data are exported and imported without any intervent.
Maybe a bug???
I use jqGrid 4.4.0 and jQuery 1.7.2 and jQuery UI 1.8.21.
For every test i'm here and thanky to all for all.
Mirko

Post edited 16:46 - 06/08/2012 by HGWheels
Post edited 16:50 - 06/08/2012 by HGWheels

I did some additional troubleshooting this morning and I think I have pinpointed the issue.

When the jqGridExport method is called and type jsonstring is used the "filters" section looks like this:

"filters":{"{"groupOp":"AND","rules":[{"field":"param1","op":"eq","data":"data1"},{"field":"param2","op":"cn","data":"data2"}]}"}

However the string should look like this:

"filters":"{"{"groupOp":"AND","rules":[{"field":"param1","op":"eq","data":"data1"},{"field":"param2","op":"cn","data":"data2"}]}"}"

Notice that the export function is not placing the filters inside of double quotes.  This is causing the jqGridSetParam method to try and interpret the '' escape characters.  Additionally if you were to remove the escape characters, then once the data is posted to the server the "filters" parameter is interpreted as json and is no longer valid.  We want the entire string posted to the server not the json structure.

I believe the offending lines from grid.import.js are 185 & 186:

   ret=ret.replace(/filters":"/,'filters":');
   ret=ret.replace(/}]}"/,'}]}');

I temporarily resolved the problem by doing a search/replace on the jqGridExport jsonstring with the following:

s/"filters":{/"filters":"{/gi

s/"}]}/"}]}"/gi

Someone with more experience with the jqGrid structure may need to make/advise on the source fix to resolve this issue.