is there an api in jqgrid to add advanced filters to post data?

by

The filter

filters:'{"groupOp":"AND","rules":[{"field":"invdate","op":"gt","data":"2007-09-06"},{"field":"invdate","op":"lt","data":"2007-10-04"},{"field":"name","op":"bw","data":"test"}]}'

which you included in the question is serialized to JSON version of the object

var myfilter = {
    groupOp: "AND",
    rules: [
        { field: "invdate", op: "gt", data: "2007-09-06" },
        { field: "invdate", op: "lt", data: "2007-10-04" },
        { field: "name",    op: "bw", data: "test"       }
    ]
}

which can be easy constructed dynamically:

// addPostDataFilters("AND");
var myfilter = { groupOp: "AND", rules: []};

// addFilteritem("invdate", "gt", "2007-09-06");
myfilter.rules.push({field:"invdate",op:"gt",data:"2007-09-06"});

// addFilteritem("invdate", "lt", "2007-10-04");
myfilter.rules.push({field:"invdate",op:"lt",data:"2007-10-04"});

// addFilteritem("name", "bw", "test");
myfilter.rules.push({field:"name",op:"bw",data:"test"});

// generate to top postdata filter code
var grid = $("#list");
grid.jqGrid({
    // all prarameters which you need
    search:true, // if you want to force the searching
    postData: { filters: JSON.stringify(myfilter)}
});

if the grid already exist you want to reload the grid with the settings you can use

grid[0].p.search = myfilter.rules.length>0;
$.extend(grid[0].p.postData,{filters:JSON.stringify(myfilter)});
grid.trigger("reloadGrid",[{page:1}]);

instead. The function JSON.stringify is supported by the most web browsers natively, but to be sure
you should include json2.js on your page.

More Related Contents:

  1. How to fire loadComplete after new row is added in jqgrid?
  2. jqGrid get “th” and “thead” using jQuery
  3. jqgrid reloadGrid with loadonce set to true
  4. can jqgrid support dropdowns in the toolbar filter fields
  5. jqGrid custom format fails on addClass
  6. jqGrid data stored in browser cache?
  7. jqGrid does not populate with data
  8. Jqgrid – grouping row level data
  9. jqgrid client side sorting with server side paging – data disappears
  10. jqGrid – saving checkbox selected state
  11. jqGrid iterate over the grid Data in a subgrid
  12. Should one replace the usage addJSONData of jqGrid to the usage of setGridParam(), and trigger(‘reloadGrid’)?
  13. How to update value of data in jqgrid
  14. JQGrid: How can I refresh a dropdown after edit?
  15. Local form editing demo and jqGrid 4.4.1
  16. Correctly calling setGridWidth on a jqGrid inside a jQueryUI Dialog
  17. jqGrid Reposition Delete Confirmation Box
  18. jqGrid treeGrid catch expand collaps events
  19. jqGrid auto filter highlighting search result
  20. jqgrid load large data set without pagination
  21. jquery with ASP.NET MVC – calling ajax enabled web service
  22. How to get jqGrid reload to go to server?
  23. How to merge cells in jqGrid 4.0
  24. In JQGrid, Is it possible to use different formatter on grouping summary cell other than column formatter?
  25. Using bootstrap select2 with JqGrid form
  26. JQGrid: Loading data into the footer row
  27. In-cell data bars in jqGrid – possible or not?
  28. Remove vertical lines in jqGrid
  29. How to create jqGrid Context Menu?
  30. jqGrid with automatic height; but has a max height & scrollbars

Leave a Comment