jQuery Datatables pagination setting

Question

I'm trying to work with the pagination of the jquery datatables. I load the data with ajax. My response is now:

aaData: [[:anonymous:, null, 2012-07-29 08:28:21, 0, 85 million, null],…]
iTotalDisplayRecords: 70
iTotalRecords: 70
sEcho: 1

All of my records (70) are shown, how can I make them paginate and have for ex 10 records per page?

I tried settings iTotalDisplayRecords to 10 but it shows the same result.

My datatable init:

myDataTable = $('#datatablesresults').dataTable({
    bProcessing  : true,
    sProcessing  : true,
    bServerSide  : true,
    sAjaxSource  : '/results/load-results?' + getParams,
    aoColumnDefs : [{'bSortable' : false, 'aTargets' : ['no-sort']}], // make the actions column unsortable
    sPaginationType : 'full_numbers',
    fnDrawCallback  : function(oSettings) {
        _initTable();
    }
});

Did you find any reason or solution to this problem.I am stuck up with same problem — bhanu.cs
– bhanu.cs, Commented Dec 30, 2015 at 15:15

Mr.G · Accepted Answer · 2013-12-06 11:47:53Z

16

try this:

$("#myDataTable").dataTables({
     "bJQueryUI":true,
      "bSort":false,
      "bPaginate":true,
      "sPaginationType":"full_numbers",
       "iDisplayLength": 10
});

answered Dec 6, 2013 at 11:47

Mr.G

3,6092 gold badges19 silver badges21 bronze badges

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

1 Comment

nielsv Over a year ago

I have the correct number of pages and I can slide through them, but I still get all my records on every tab. Like this: Showing 21 to 30 of 70 entries, but he shows all 70

Hasnain Mehmood · Accepted Answer · 2017-01-09 06:28:15Z

3

$('#example').dataTable( {
  "pagingType": "full_numbers"
} );


DataTables has six built-in paging button arrangements:

numbers - Page number buttons only (1.10.8)
simple - 'Previous' and 'Next' buttons only
simple_numbers - 'Previous' and 'Next' buttons, plus page numbers
full - 'First', 'Previous', 'Next' and 'Last' buttons
full_numbers - 'First', 'Previous', 'Next' and 'Last' buttons, plus page numbers
first_last_numbers - 'First' and 'Last' buttons, plus page numbers

answered Jan 9, 2017 at 6:28

Hasnain Mehmood

4275 silver badges5 bronze badges

1 Comment

CHW Nov 14 at 7:45

Note that as of v2.1 this feature has been deprecated, see datatables.net/reference/option/pagingType

Aleksandar Mitic · Accepted Answer · 2020-02-25 11:12:25Z

0

For anyone looking simply how to change number of pages displayed in pagination here is code snippet.

jQuery.fn.dataTableExt.pager.numbers_length = 10;

$(document).ready(function() {
  // Basic datatable
  $('#datatable').DataTable();
  .... rest of the code below....

You can change number of pages displayed in pagination changing the value '10' in first line.

answered Feb 25, 2020 at 11:12

Aleksandar Mitic

3694 silver badges12 bronze badges

1 Comment

Onur Buyukcaglar Over a year ago

Exactly was searching for this info, thank you very much.

Collectives™ on Stack Overflow

jQuery Datatables pagination setting

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related