datatable pagination

datatable pagination

thejus_rthejus_r Posts: 2Questions: 0Answers: 0
edited July 2013 in General
i am trying to use datatable and it is partially successfull. but pagination is not working. its showing 1 to 10 of 10 entries (filtered from 22,289 total entries). the json output has all the 22,289 entries.
[code]
$(document).ready(function() {
$('#example').dataTable( {

"bProcessing": "true",
"bServerSide": "true",
"bPaginate": "true",
"iDisplayLength": 10,
"sPaginationType": "full_numbers",
"sAjaxSource": "fac_branchassetdetails.php",


} );
} );
[/code]

what else should be done to make pagination work
the json output is given below

{"sEcho":0,"iTotalRecords":"22289","iTotalDisplayRecords":"22289","aaData":[["301","1","40353",....]]}

Replies

  • allanallan Posts: 63,512Questions: 1Answers: 10,472 Site admin
    If you have server-side processing enabled, why is your script returning all 22289 rows?

    Allan
  • thejus_rthejus_r Posts: 2Questions: 0Answers: 0
    i want to display all 22000 records pagewise..
This discussion has been closed.