Preserve page number while sorting on the datatable on server side processing.

GenieMind

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 ?

colin

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