How to show 5 rows instead of default 10 rows in datatable?

Question

My datatable looks like this:

Here it is showing default 10 datas in a single page.I need to show 1 to 5 of 58 entries so i tried to put max:5 but it is not working.I need to show only 5 data and the user may use pagination for other data access.

My code for datatable is:

var table = $('#firstTable').DataTable({
        "processing" : true,
        "scrollY": 410,
        "scrollX": true,
        order: [ 0, 'asc' ],
        max :5,
        "ajax" : {
            "url" : A_PAGE_CONTEXT_PATH + "/form/api/getAllSelection/all",
            dataSrc : ''
        },
        "columns" : [ {
            "data" : "selectionId"
        }, {
            "data" : "selectionDate"
        }, {
            "data" : "selectedBy"
        }, {
            "data" : "eximPanNo"
        }, {
            "data" : "eximPanName"
        }, {
            "data" : "eximPanAddr"
        }, {
            "data" : "eximPanPhone"
        }, {
            "data" : "selectionType"
        } ]
    });

4b0 · Accepted Answer · 2019-01-24 04:43:12Z

14

There is a option called pageLength. You can set this for show only 5 entries.

 var table = $('#firstTable').DataTable({
    pageLength : 5,
    lengthMenu: [[5, 10, 20, -1], [5, 10, 20, 'Todos']]
  })

For details see : https://datatables.net/forums/discussion/46346/how-to-show-less-than-10-rows

answered Jan 24, 2019 at 4:43

4b0

22.4k30 gold badges97 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shidersz · Accepted Answer · 2019-01-24 04:42:37Z

2

You need to use option pageLength, like this:

var table = $('#firstTable').DataTable(
{
    "processing": true,
    "scrollY": 410,
    "scrollX": true,
    order: [ 0, 'asc' ],
    //max :5, WRONG OPTION!
    "pageLength": 5,
    "ajax" : {
        "url" : A_PAGE_CONTEXT_PATH + "/form/api/getAllSelection/all",
        dataSrc : ''
    },
    "columns" : [ {
        "data" : "selectionId"
    }, {
        "data" : "selectionDate"
    }, {
        "data" : "selectedBy"
    }, {
        "data" : "eximPanNo"
    }, {
        "data" : "eximPanName"
    }, {
        "data" : "eximPanAddr"
    }, {
        "data" : "eximPanPhone"
    }, {
        "data" : "selectionType"
    } ]
});

answered Jan 24, 2019 at 4:42

Shidersz

17.2k2 gold badges28 silver badges52 bronze badges

Collectives™ on Stack Overflow

How to show 5 rows instead of default 10 rows in datatable?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related