jQuery Datatables pagination setting

user_1775531 0
Viewed 82508

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();
    }
});
jquery-datatables datatables pagination jquery javascript
3 Answers

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.

user_31957400
Related