Guriddo » Topic: Call Grid search with user values

Call Grid search with user values

Guriddo
Call Grid search with user values

This topic has 8 replies, 3 voices, and was last updated 12 years, 11 months ago by jags.

Creator

Topic
April 22, 2013 at 2:19 pm #80909

pankajpandey
Participant

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
Creator

Topic

Viewing 8 replies - 1 through 8 (of 8 total)

Author

Replies

April 22, 2013 at 3:30 pm #100952

pankajpandey

Participant

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.

<div class="sfcode">$("#search").click(function() {<br />
var searchFiler = $("#filter").val(), grid = $("#list"), f;<br />
<br />
if (searchFiler.length === 0) {<br />
grid[0].p.search = false;<br />
$.extend(grid[0].p.postData,{filters:""});<br />
}<br />
f = {groupOp:"OR",rules:[]};<br />
f.rules.push({field:"name",op:"cn",data:searchFiler});<br />
f.rules.push({field:"note",op:"cn",data:searchFiler});<br />
grid[0].p.search = true;<br />
$.extend(grid[0].p.postData,{filters:JSON.stringify(f)});<br />
grid.trigger("reloadGrid",[{page:1,current:true}]);<br />
});</div>

<div class="sfcode">$("#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}]);

});</div>

April 22, 2013 at 3:34 pm #100953

OlegK

Participant

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

April 23, 2013 at 9:22 am #100954

pankajpandey

Participant

Awesome, worked like a charm Laugh .

Thanks Oleg!

Regards,

Pankaj

May 17, 2013 at 10:20 am #101021

jags

Participant

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]});<br /><br />At least it didn

1	f.rules.push({field:"id",op:"eq",data:[id1,id2]});<br /><br />At least it didn

May 17, 2013 at 10:28 am #101022

OlegK

Participant

here

May 17, 2013 at 12:28 pm #101023

jags

Participant

Hmm…Is that link you gave working? It shows this same topic or do I miss something. But what I

May 17, 2013 at 12:53 pm #101024

OlegK

Participant

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.

May 17, 2013 at 1:25 pm #101025

Call Grid search with user values

Search Forum

Recent Replies

Forum Statistics

UserOnline