JSFiddle
I’m trying to search some text in more than one column in a grid with or condition. Meaning if the text that I’m searching for is present either in any of the columns the grid should show those rows.
Code works perfectly when I specify one column as below:
$("#jqxgrid").jqxGrid('addfilter', 'firstname', filtergroup);
// apply the filters.
$("#jqxgrid").jqxGrid('applyfilters');
If I add one more column to the filter, it fails and no data is shown in the grid. Check the fiddle for more info.
$("#jqxgrid").jqxGrid('addfilter', 'firstname', filtergroup);
$("#jqxgrid").jqxGrid('addfilter', 'lastname', filtergroup);
// apply the filters.
$("#jqxgrid").jqxGrid('applyfilters');