DataTable only returning 1000 entries from 1544 records

Hubmate

Hello,

I'm using DataTables on this page: http://dutypoint-4097839.hs-sites.com/downloads As you can see, it appears the entries are being 'capped' or limited to 1000, when the database they are being retrieved from has 1544 entries. Here is the code I am using:

var otable = $('#example').dataTable({
    "ordering": false,
    "searching": true,
    /*stateSave: true,*/
    "lengthMenu": [[10, 25, 50], ["10 Results Per Page", "25 Results Per Page", "50 Results Per Page"]],
    "columnDefs": [ { "targets": [ 2 ], "visible": false, "searchable": true } ]
});

I am also using a 'client' side setup, as in, the data is supplied as HTML, not from a server. Does anyone know why the entries are being limited to 1000? I've searched the docs and can't find anything obvious.

Thanks,

Steve

tangerine

the data is supplied as HTML, not from a server

But you are also saying that the data is retrieved from a database in the first place. It seems likely that some limit is applied in your database query code.

kthorngren

I copied the lines between the tbody tag of the #example table and grepped the text for "<tr" and found 1000 occurrences. It seems your HTML table only has 1000 rows. Not sure how you are building the table but the problem seems to be in that process.

Kevin