Show ALL option

Go tablein question
Go to Features of the Data Tables

Pagination: Uncheck Enable pagination of the table (viewing only a certain number of rows at a time) by the visitor.
Show rows per page.

Hi,

thanks for your post, and sorry for the trouble.

Yes, as JGravesNBS mentions, you could either uncheck that checkbox to turn off Pagination entirely, or check out the TablePress Extension from https://tablepress.org/extensions/length-change-all-entry/ which will add an “All” entry to the list.

Regards,
Tobias

The plugin works nicely. Thanks!

Now for another request. Is there a way to have the list default to “All”?

In other words, have the full table shown at which point the visitor can change the number shown if desired.

Hi,

great to hear that this worked! ??
Making “All” the value that is chosen by default should be possible with a small “Custom Command” for the DataTables JS library. Please try adding

"iDisplayLength": -1

to the “Custom Commands” textfield on the table’s “Edit” screen.

Regards,
Tobias

Great – that snippet worked.

Now I need to add it to an existing Custom Command:

"aoColumnDefs": [ { "bSortable": false, "aTargets": [ 7 ] }, { "asSorting": [ "desc", "asc" ], "aTargets": [ 1,2,3,4,5,6 ] } ]

Any ideas?

Never mind. I simply added it to the end:

“aoColumnDefs”: [ { “bSortable”: false, “aTargets”: [ 7 ] }, { “asSorting”: [ “desc”, “asc” ], “aTargets”: [ 1,2,3,4,5,6 ] } ], “iDisplayLength”: -1

Hi,

yes, just add it to the end, separated by a comma.

Best wishes,
Tobias