jQuery Grid Plugin - jqGrid - Topic: Building postdata

kxlin on Building postdata

Sat, 25 Sep 2010 06:01:37 +0300

I figured out by myself:

    beforeRequest: function() {
           var inputlabel1 = ' where 1=1 ';
           var postData = $("#project").jqGrid('getGridParam','postData') ;
           var colModel = $("#project").jqGrid('getGridParam','colModel') ;
           $.each(postData,function(the_key,the_value) {
               $.each(colModel, function(idx,the_item){
                   if (the_item.index==the_key) inputlabel1 += ' and '+ the_key + " like '%"+the_value+"%'"
               })
           });
           if (postData.sidx) inputlabel1 += ' order by '+ postData.sidx + ' ' + postData.sord
           //alert(inputlabel1);
           postData.inputlabel1=inputlabel1;
           $("#project").jqGrid('setGridParam',{'postData':postData});
   },

kxlin on Building postdata

Fri, 24 Sep 2010 20:55:18 +0300

The reason why I need to do this is because I'm not using PHP/ASP and have little control over server side script.

kxlin on Building postdata

Fri, 24 Sep 2010 20:52:33 +0300

I'm new to jqGrid, so bear with me if this is obvious in the manual... 🙂

I have the jqGrid defined as:

jQuery("#project").jqGrid({
   url: 'myurl',
   postData: {
        whereclause: ""
   },
   datatype: 'json',
......

By default, when requesting new data jqGrid is appending myurl like this:

myurl?page=1&rows=10&mysort=myindex&sord=asc&colname='abc'

Instead, I want to build the whereclause in postdata on the fly:

myurl?page=1&rows=10&whereclause="where colname='abc' order by myindex asc"

Basically I have a SQL built into myurl: "select * from mytable %1", and the whereclause will be replacing the %1.

Any idea how I should proceed? Thanks in advance.