jQuery Grid Plugin - jqGrid - Topic: Call Grid search with user values

jags on Call Grid search with user values

Fri, 17 May 2013 13:25:53 +0300

Yep, that worked perfectly. Thank you very much for all your help Oleg!

OlegK on Call Grid search with user values

Fri, 17 May 2013 12:53:34 +0300

Sorry, the correct link to the docomentation is here. If you need implement (id=1 OR id = 2) AND col2 = 456 then you should create subgroup with groupOp:"OR" and use groupOp:"AND" on the top level. See the answer for the code example.

jags on Call Grid search with user values

Fri, 17 May 2013 12:28:08 +0300

Hmm…Is that link you gave working? It shows this same topic or do I miss something. But what I´m trying to achieve is, that for example I have 2 grid columns and I want to filter them like this based on user selections:

(id=1 OR id = 2) AND col2 = 456

So for example the code could be if possible:

f = {groupOp:"AND",rules:[]};
f.rules.push({field:"id",op:"eq",data:[1,2]});
f.rules.push({field:"col2",op:"eq",data:456});

OlegK on Call Grid search with user values

Fri, 17 May 2013 10:28:56 +0300

here is described format of postData.

With

f.rules.push({field:"id",op:"eq",data:[id1,id2]});

you mean probably something like id=123 OR id=345.

You should just use groupOp: "OR" like I described in previously referenced answers.

jags on Call Grid search with user values

Fri, 17 May 2013 10:20:19 +0300

Where can I find some documentation about the filters option in postData? Is it possible to pass multiple values in data -property? For example:

f.rules.push({field:"id",op:"eq",data:[id1,id2]});

At least it didn´t work for me....

pankajpandey on Call Grid search with user values

Tue, 23 Apr 2013 09:22:59 +0300

Awesome, worked like a charm .

Thanks Oleg!

Regards,

Pankaj

OlegK on Call Grid search with user values

Mon, 22 Apr 2013 15:34:36 +0300

Hello!

I posted many variation on the stackoverflow.com what can be done to do what you need. Look at the answer or this one for example.

Best regards
Oleg

pankajpandey on Call Grid search with user values

Mon, 22 Apr 2013 15:30:02 +0300

Got below code from google. Can someone suggest how to use this with local data. I am loading the grid with loadonce=true and don't want to send the request back to the server.


$("#search").click(function() {
    var searchFiler = $("#filter").val(), grid = $("#list"), f;

    if (searchFiler.length === 0) {
        grid[0].p.search = false;
        $.extend(grid[0].p.postData,{filters:""});
    }
    f = {groupOp:"OR",rules:[]};
    f.rules.push({field:"name",op:"cn",data:searchFiler});
    f.rules.push({field:"note",op:"cn",data:searchFiler});
    grid[0].p.search = true;
    $.extend(grid[0].p.postData,{filters:JSON.stringify(f)});
    grid.trigger("reloadGrid",[{page:1,current:true}]);
});

pankajpandey on Call Grid search with user values

Mon, 22 Apr 2013 14:19:59 +0300

Hi,

I have a grid with some data in it. Based on certain values selected by User in other form, I have to call the multi Search of jqGrid. I have the column name/value pairs on which the search should be performed, but couldn't find a way to call the search on the grid with these arguments, similar to the way we do multi search from the Search toolbar.

Anyone has any suggestions?

Thanks!

Regards,

Pankaj