Data-table jQuery pagination issue

Question

This is my jQuery data table code.

$('#dynamic_list').DataTable({
        "order": [[ 0, "desc" ]],
        "iDisplayLength": '100',
});

I have more than 500 rows in data-table but pagination doesn't work properly and also data-table pagination showing

Showing 1 to **0,100** of 1,500 entries

Here you can see comma separated between 0,100. That might be create the problem in pagination. I'm not sure.

Can you guys help me out on this ?

Thanks in advance!

Can you reproduce the issue and share the code in Jsfiddle?

Rajshekar Reddy
– Rajshekar Reddy

2016-04-26 06:42:51 +00:00
Commented Apr 26, 2016 at 6:42 — Rajshekar Reddy
– Rajshekar Reddy, Commented Apr 26, 2016 at 6:42

Samyukta R. · Accepted Answer · 2016-04-26 06:38:01Z

1

Have you tried adding extra parameters in your Datatable

$('#dynamic_list').DataTable({
        "sDom": 'rt<"dtPagination"lp><"clear">',
        "order": [[ 0, "desc" ]],
        "iDisplayLength": 100,
        "bPaginate": true,
        "sPaginationType": "full_numbers",
        "bServerSide": true            
});

answered Apr 26, 2016 at 6:38

Samyukta R.

1541 gold badge1 silver badge15 bronze badges

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

8 Comments

Rajshekar Reddy Over a year ago

what is the need of "bServerSide": true here?

Samyukta R. Over a year ago

with bServerSide, you can use paging to control performance. rather than returning all records, you could return records 1 through 10, 11 through 20, etc., whatever is needed for that page.

Samyukta R. Over a year ago

@ Vijay V. It's my pleasure to help you :)

Rajshekar Reddy Over a year ago

@SamyuktaR. thats true but it would require alot of rework for him if at all he is not using server side processing..

Samyukta R. Over a year ago

@ Reddy Since he says the code is working, I think he already have implemented the server side processing at his end.

|

Collectives™ on Stack Overflow

Data-table jQuery pagination issue

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related