Geek asks and answers

Filter toolbar without loadonce: true?

I am using jqgrid with a filter (column) toolbar option ... The total amount of data is about 10,000 ... Therefore, there seems to be some boot delay, as the config parameter is set to loadonce: true;

Any way to implement filter column function with loadonce: false? Because the delay in loading data is ok with loadonce: false. If I get the opportunity to add a column filter with loadonce: false, this will work fine ...

+3
source share
1 answer

If you have about 10,000 lines, then, of course, it is better to implement pagination on the server side, sorting and filtering. I recommend using filterToolbar with a parameter stringResult:trueif you are not already using it. In the case when jqGrid sends a filtersparameter to the server in the same format as the advanced search in the form of do . Thus, you will need to implement a server-side method that uses the following input parameter from jqGrid:

  • Parameters
  • sidxand sorddetermine the sort order of the data. Information is indicated ORDER BYin the relevant statement SELECT.
  • _search true, filters , WHERE SELECT.
  • page rows , , , .

, , , , , .

+4

More articles:


All Articles