filter options from database

[orlando_acevedo]

Hi pqTeam,

I have an infinite scrolling grid that I am upgrading to version 5.6. Since the data is loaded incrementally, I need to feed the filter options directly from the database.
The code I found on the forum and documentation is not working though, and when runs, it makes the filter be blank.
Here is what I have:

Code: [Select]


$.getJSON('@Url.Action("AuditFilterOptions", "Audits")', function (data) {

            filterMG = $("#grid_audits").pqGrid("getColumn", { dataIndx: 'ManagementGroup' }).filter;
            filterMG.cache = null;
            filterMG.options = data.ManagementGroups;

            $("#grid_audits").pqGrid("refreshHeader");
        });




Thank you,

OA

[paramvir]

data.ManagementGroups should be array of objects in this format.

Code: [Select]

[
  {ManagementGroup: val1},
  {ManagementGroup: val2},
  {ManagementGroup: val3},
  ...
]


[orlando_acevedo]

That worked.


Thank you!!!


OA.