Start parameter is 0 in server side

Start parameter is 0 in server side

jportugaljportugal Posts: 1Questions: 1Answers: 0

When i change page, the start parameter is correct, 0 at first page, 10 at second, etc (assuming pagelenght is 10).

The problem is when I order the table, then, the start parameter is allways 0 which implies that paging is completely lost.

My backend is c# (asp mvc 5) and this is how i'm reciving the parameter

var start = Request.Form.GetValues("start").FirstOrDefault();

And this is my datatable

var table = $('#demoGrid').DataTable
        ({
        processing: true,
        serverSide: true,
        filter: true,
        orderMulti: false,
        paging: true,
        pageLength: 10,
        colReorder:
            {
                fixedColumnsLeft: 1
            },
        ajax:
            {
            "url": '@Url.Action("Cargar")',
            "type": "POST",
            "datatype": "json",            
            },
        order: [[1, 'desc']],
            "columns": [
            { data: null, name: "Accion", "autoWidth": true, orderable: false, width: "8%", defaultContent: stringAcciones, className: "text-center" },
            { "data": "Codigo_delfos", "name": "Codigo_delfos", "autoWidth": true}]
            //much more columns
        });

what am i doing wrong?

Thanks so much!

This question has an accepted answers - jump to answer

Answers

  • colincolin Posts: 15,240Questions: 1Answers: 2,599
    Answer ✓

    Hi @jportugal ,

    Yep, the ordering resets the paging. It can be overwritten though with some code, see the last example in this thread,

    Cheers,

    Colin

This discussion has been closed.