Forum
22:08
31/05/2013
Hi,
I have implemented Jqgrid search on sinlge column using below code. I have a textbox,when i enter some text and click on a button it will filter the data on JqGrid. Here i am doing search on Name column.
$('#btnSearchAssociatedClients').click(function() {
var grid = $('#tblAssociateClientSummary');
var relatedClientName = $('#txtRelatedClientName').val();
var postdata = grid.jqGrid('getGridParam', 'postData');
// build up the filter
// ['equal','not equal', 'less', 'less or equal','greater','greater or equal', 'begins with','does not begin with','is in','is not in','ends with','does not end with','contains','does not contain']
// ['eq','ne','lt','le','gt','ge','bw','bn','in','ni','ew','en','cn','nc']
var myfilter = { groupOp: "OR", rules: [] };
myfilter.rules.push({ field: "Name", op: "cn", data: relatedClientName });
$.extend(postdata, { filters: myfilter });
grid.jqGrid('setGridParam', { search: relatedClientName.length > 1, postData: postdata });
grid.trigger("reloadGrid", [{ page: 1 }]);
});
In the code the Name column is using below formatter so it will combine first name and last name.
var nameFormatter = function(cellValue, options, rowData) {
return rowData.FirstName+" "+rowData.LastName;
};
Note:- The data also contains Name column which has different data.
My problem is the search is working on Name column data, not on the displayed data.. Please provide me the solution how to implement search on formatted data.
Most Users Ever Online: 715
Currently Online:
33 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66