Datagrid: Filters with pagination

[rangaNadha]

Hi,

I have integrated filters with the pagination.
If i set remote pagination and remoteFilter, pagination is not working.

So i changed my code according to the below link
http://stackoverflow.com/questions/25698071/easyui-filter-and-serverside-pagination-jquery-conflict
- Both pagination and filters are working for less amount of records(5000 Max). It is building the pagination locally not remotely.
- If i test this with 100000 records. It is not loading the records.

DataGrid Config:
dataTable.datagrid({
  pagination:false,
  remoteFilter:true,
  pageSize:50,
  remoteSort:true,
   url="userList.htm"       
});

<table id="usersTable" class="easyui-datagrid work_table work_table1" style="width: 100%; height: 98% !important"
   sortName="employeeNo" sortOrder="asc" rownumbers="false" toolbar="#toolbar"
   data-options="singleSelect:true, onDblClickRow:userManagement.getDataById">

Please help me to fix this issue.

Thanks

[stworthy]

To use the server side filtering and pagination, the 'pagination' and 'remoteFilter' must be set to true.

Code:

dataTable.datagrid({
  pagination:true,
  remoteFilter:true,
  pageSize:50,
  remoteSort:true,
  url:"userList.htm"        
});

On your server side, you can get 'filterRules','page','rows','sort','order' request parameters. Please notice that the 'filterRules' is a string, you need to parse it and decode the filter rules.

[rangaNadha]

Hi stworthy,

Thanks for your reply.

I have changed the configuration, but filterRules are not passing to the serverside.
Did i miss anything?

[stworthy]

Please look at this example http://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=Remote%20Filtering%20on%20DataGrid

[rangaNadha]

Thanks stworthy,

Issue resolved.

Problem: If there are no filters it is not passing the filterRule value.

[jbrave]

Hi there - this is the exact problem I am having.

remoteFilter, remoteSort and Pagination works fine ONLY when the filterRule is active.   

If there is nothing filtered in the grid, the Pagination does not work.  Clicking on the next page does not send to the server a request for the next page of records.

If there is a solution I would be very grateful.