Reloading filter drop down lists

[mjf784927Participant]

Is there a way after the grid loads and a filter is applied that the filter row drop down lists can be refreshed? I am using server side calls to bring in a chunk of data at a time but have a method to update the source for the filteritems datasource. Just need a way to refresh the filterrow with that new data.

{ text: ‘Domain’, filtertype: getFilterType(filterLists.Domain), filteritems: filterLists.Domain, datafield: ‘Domain’, pinned: true, renderer: columnrenderer, cellsrenderer: cellsrenderer, width: 120 }

Thanks
Mike

[Peter StoevKeymaster]

Hi Mike,

Have you tried the “refreshfilterrow” method?

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[mjf784927Participant]

Yes I have…here’s a small piece of test code:

$(“#jqxgrid”).on(“filter”, function (event) {
alert(“filter changed”);
$.ajax({
url: filterablesURL + “?reporttype=” + reporttype + “&reportname=” + reportname,
type: “POST”,
dataType: “json”,
cache: false,
}).done(function (data) {
data.AgentStatus = [99, 98, 97];
data.ServerStatus = [‘xxxxxx’];
alert(data.AgentStatus);
alert(data.ServerStatus);
filterLists = data;
alert(filterLists.AgentStatus);
alert(filterLists.ServerStatus);
$(‘#jqxgrid’).jqxGrid(‘refreshfilterrow’);
})
});

Basically just for testing I called the same code when it detects the filter change as I call in the initial load to populate the filter ddl’s. Then I changed a few values and called the ‘refreshfilterrow’. The ddl’s keep their original values. I see the new values in my test alerts.

[Peter StoevKeymaster]

Hi Mike,

I suppose that you will have to update the column’s filteritems property before calling “refreshfilterrow”. Otherwise, you will refresh the same row and the same items.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[mjf784927Participant]

That did it!

I added:

$(‘#jqxgrid’).jqxGrid(‘setcolumnproperty’, ‘AgentStatus’, ‘filteritems’, filterLists.AgentStatus);
$(‘#jqxgrid’).jqxGrid(‘setcolumnproperty’, ‘ServerStatus’, ‘filteritems’, filterLists.ServerStatus);

and actually did not need the:

$(‘#jqxgrid’).jqxGrid(‘refreshfilterrow’);

works like a champ!

Thanks
Mike

[Author]

Posts