jqgrid 在重新加载时保留过滤器 [英] jqgrid retain filter on reload

问题描述

这个问题已经很多了，请原谅我再问一次.

This question has been as a lot so please forgive me asking again.

我有一个从 url 加载的网格.

I have a grid loaded from a url.

我使用 loadonce: true

I use loadonce: true

我使用过滤器工具栏:

$("#status").jqGrid('filterToolbar', { stringResult:true, searchOnEnter:false, autosearch: true, defaultSearch: "cn" });

我有一个下拉搜索列表，我可以从中选择我要查找的内容.效果很好.

I have a dropdown search list from which I can select what I'm looking for. Works great.

我有一个导航按钮，我每 30 秒单击一次以启动重新加载.效果很好.

I have a navbutton I click to initiate a reload every 30 seconds. Works great.

$("#status").jqGrid('navButtonAdd','#statuspager', { caption: '', buttonicon: 'ui-icon-play', onClickButton: function ()
{
stint = setInterval (function() {
      postfilt = $("#status").jqGrid('getGridParam', 'postData').filter;

      $("#status").jqGrid('setGridParam',{
             url: './ar_status.cgi?systemtype=' + systype,
             datatype: "json",
             postData: postfilt,
             search: true,
             loadtext: "Refreshing grid...",
             loadonce: true,
             loadui: "block"
      });
      $("#status").jqGrid().trigger("reloadGrid");
}, 30000);
},
title: 'Start Auto Refresh (every 30 sec.)'
});

使用谷歌浏览器，我可以看到指定的过滤器被发布到服务器:

Using google chrome I can see the filters that were specified being posted to the server:

systemtype:production
_search:true
nd:1358887757603
rows:1000
page:1
sidx:system
sord:asc
totalrows:700
filters:{"groupOp":"AND","rules":[{"field":"system","op":"eq","data":"ATTDA02"}]}

我可以在重新加载之间更改过滤器并查看新的甚至多个过滤器:

I can change the filter between reloads and see the new, even multiple filters:

systemtype:production
_search:true
nd:1358887847592
rows:1000
page:1
sidx:system
sord:asc
totalrows:700
filters:{"groupOp":"AND","rules":[{"field":"system","op":"eq","data":"ATTDA02"},{"field":"dow","op":"cn","data":"MO"}]}

我在初始加载时使用 multipleSearch: true.我很确定它会在重新加载时保留

I am using multipleSearch: true on the initial load. I'm pretty sure that's retained on reload

在网格上，过滤器工具栏保留了我的过滤条件，包括文本和选择，但是当网格重新加载时，过滤器将被忽略并且整个数据集都显示在网格中.

On the grid, the filtertoolbar retains my filter criteria, both text and selects, but when the grid reloads, the filters are ignored and the entire dataset is diplayed in the grid.

我已经尝试了很多在 SO 上发布的示例.我已经尝试将 [{current:true}] 添加到 reloadGrid 调用中 - 没有区别.我似乎无法在重新加载时保留和应用过滤器.

I've tried many examples posted here on SO. I've tried adding [{current:true}] to the reloadGrid call - no difference. I can't seem to retain and apply the filters on a reload.

我希望重新加载始终从服务器返回完整数据集(这很好)，并允许当前过滤器设置控制重新加载后显示的内容.我不想使用 postdata 来构建新的 SQL 选择语句 - 服务器端过滤，因为用户随时可能想要单击暂停按钮，选择一个新过滤器并从整个数据集中查看其他内容，而无需再次重新加载.

I would like the reload to always return the full dataset from the server (which happens fine), and allow the current filter settings to control what is shown after the reload. I do not want to use the postdata to build a new SQL select statement - server side filtering, because at any time the user may want to click the pause button, select a new filter and view something else from the entire dataset without another reload.

$("#status").jqGrid('navButtonAdd','#statuspager', { caption: '', buttonicon: 'ui-icon-pause', onClickButton: function ()
{
   clearInterval(stint);
},
title: 'End Auto Refresh'
});

如何在不使用 cookie 的情况下做到这一点，正如我在一篇文章中看到的那样?

How can this be done without using cookies, as I saw in one post?

我可以尝试使用 jqGridExport'ing postfilt var，然后使用 jqGridImport'ing 但希望有更直接的方法.我什至不确定这会有所帮助，因为我已经通过 postData 在网格中拥有了我需要的一切.

I could try using jqGridExport'ing the postfilt var, and then jqGridImport'ing it but was hoping for a more direct approach. I'm not even sure this would help since I already have everything I need right here in the grid via postData.

作为旁注，在我上面的 setGridParam 中，我指定的加载文本永远不会显示.而是显示默认的正在加载...".所有其他参数都有效.

As a side note, in my setGridParam above, the loadtext I specify is never displayed. Instead, the default "Loading..." is displayed. All of the other parameters are working.

非常感谢，迈克

解决方案.从服务器重新加载 [json] 后保留过滤器、排序索引和排序顺序的完整 loadComplete:

Solution. The complete loadComplete to retain filters, sort index and sort order after a [json] reload from the server:

                    loadComplete: function() {
                            var $this = $(this);
                            postfilt = $this.jqGrid('getGridParam','postData').filters;
                            postsord = $this.jqGrid('getGridParam','postData').sord;
                            postsort = $this.jqGrid('getGridParam','postData').sidx;

                            if ($this.jqGrid("getGridParam", "datatype") === "json") {
                                    setTimeout(function () {
                                            $this.jqGrid("setGridParam", {
                                                    datatype: "local",
                                                    postData: {filters: postfilt, sord: postsord, sidx: postsort},
                                                    search: true
                                            });

                                            $this.trigger("reloadGrid");
                                    }, 50);
                            }
                    }

推荐答案

我不确定，但我想你的第一个问题的起源可能是混合 postData.filters 和 postData 和使用 filter 属性而不是过滤器``.你用

I am not sure, but I suppose that the origin of your first problem could be mixing postData.filters and postData and usage filter property instead of filters``. You use

postfilt = $("#status").jqGrid('getGridParam', 'postData').filter;

获取filter 属性而不是filters.你得到 undefined 值.所以将 postData 设置为 postfilt 没有任何意义.

to get filter property instead of filters. You get undefined value. So the setting postData to postfilt means nothing.

下一个问题是服务器响应包含未过滤的数据.要强制本地过滤数据，您必须在从服务器加载完成后重新加载网格.您可以在 loadComplete 中执行此操作.如果需要，您可以在这里设置 postData.filter，设置 search: true 并触发 reloadGrid 事件.重要的是只执行此一次以防止递归，并且在这种情况下您不能将 datatype 设置回 "json".datatype 将更改为 "local" 并在使用 loadonce: true 选项的情况下从服务器加载结束.如果您想本地应用过滤，您必须使用选项datatype: "local", search: true 和postData 重新加载网格一次过滤器 指定需要应用的过滤器.请参阅答案或another 做另一件事，但你需要的代码会非常接近.

The next problem is that the server response contains non-filtered data. To force filtering the data locally you have to reload the grid once after the loading from the server have finished. You can do this inside of loadComplete. Exactly here you can set postData.filter if required, set search: true and trigger reloadGrid event. It's important only to do this once to have no recursion and you must don't set datatype back to "json" in the case. The datatype will be changed to "local" and the end of loading from the server in case of usage loadonce: true option. If you want apply filtering locally you have to reload grid once with options datatype: "local", search: true and postData having filters specifying the filter which need by applied. See the code from the answer or another one which do another things, but the code which you need will be very close.

这篇关于jqgrid 在重新加载时保留过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！