Preserve page number while sorting on the datatable on server side processing.
Preserve page number while sorting on the datatable on server side processing.
 GenieMind            
            
                Posts: 1Questions: 1Answers: 0
GenieMind            
            
                Posts: 1Questions: 1Answers: 0            
            I have implemented a jquery datatable in asp mvc. The records are being fetched correctly, and the sorting working correctly. The data table operates via the server side.
However, I encountered a small issue. When I am on page 3 of the datatable, I perform a sorting but the datable refreshes, returns to page 1 and only sorts records on page 1. What I want to achieve is to make sorting only on the current page that I am.
I have tried making the stateSave to true like: But the issue persists.
```var table = $('#employeetable').DataTable({
                "ajax": {
                    "url": "/Employee/GetList",
                    "type": "POST",
                    "datatype": "json"
                },
                "columns": [
                    { "data": "Name", "name": "Name" },
                    { "data": "Office", "name": "Office" },
                    { "data": "Position", "name": "Position" },
                    { "data": "Age", "name": "Age" },
                    { "data": "Salary", "name": "Salary" },
                ],
                "serverSide": true,
                "order": [0, "asc"],
                "processing": true,
                "stateSave": true
            });```
Can someone please help to resolve this ?
Answers
Hi @GenieMind ,
As I said last week on StackOverflow, that's not possible. The sort affects the entire data set, not just the visible records.
Cheers,
Colin