DataTable: lazy loading with paginator/sort/filter info
Posted: 29 Jan 2020, 08:37
How to collect info about paginator state and filter/sort state of columns to make a complete ajax request?
We have onPage event with argument containing information about paginator state (current page, rows per page), but we need to manually take values from sortField and sortOrder properties to add this into request and make correct DB query.
Also, the information from filter fields need to be included into this argument becouse total rows count would be reduced after filtering on a DB level.
We have onPage event with argument containing information about paginator state (current page, rows per page), but we need to manually take values from sortField and sortOrder properties to add this into request and make correct DB query.
Also, the information from filter fields need to be included into this argument becouse total rows count would be reduced after filtering on a DB level.