jQuery Grid Plugin - jqGridForum

Topic RSS

Building postdata

24/09/2010
20:52

kxlin

Member

Members

Forum Posts: 16

Member Since:
24/09/2010

Offline

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.

24/09/2010
20:55

kxlin

Member

Members

Forum Posts: 16

Member Since:
24/09/2010

Offline

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

25/09/2010
06:01

kxlin

Member

Members

Forum Posts: 16

Member Since:
24/09/2010

Offline

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});
   },

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
76 Guest(s)

Currently Browsing this Page:
1 Guest(s)