Hi, I would like to request feature to be added to roadmap.
Problem: At the moment, there is no option to customize number of results per page as only default given 5,10, 25, 50, ..., all. When providing data services for clients under membership model , it is handy to limit this functionality. However, with small numbers up to 25-50 it is ok but you do not want to give ALL and in tables with more than couple of hundred thousands record it breaks.
Value:
fix error when all selected on big tables
give flexibility to provide own custom number for aligning with memberships
Thanks for the suggestion, Alex, I will forward it to our development team.
You can't use this option out-of-the-box, but there's a way to do it.
You need to open this file: ../wp-content/plugins/wpdatatables/templates/admin/table-settings/table_settings_block.inc.php and around line 335 you'll see this:
And the last thing to do is to go to line 499 of the same file, and modify it so it looks like this:
public function setDisplayLength($length) {
if (!in_array($length, array(1, 5, 10, 20, 25, 30, 50, 100, 200, 1000))) {
return false;
}
So, again, replace -1 with 1000.
You may also want to add the value in ../wp-content/plugins/wpdatatables/templates/admin/table-settings/column_settings_panel.inc.php around line 570, if you wish to add that value to possible column options (if you have a select-box filter, or selectbox editor input type, this would be the number of values displayed in those drop-downs).
Please make sure to delete cache in your browser after you apply the changes.
This removes the ALL option, but you can freely add new values in there.
Hi, I would like to request feature to be added to roadmap.
Problem: At the moment, there is no option to customize number of results per page as only default given 5,10, 25, 50, ..., all. When providing data services for clients under membership model , it is handy to limit this functionality. However, with small numbers up to 25-50 it is ok but you do not want to give ALL and in tables with more than couple of hundred thousands record it breaks.
Value:
Thanks for the suggestion, Alex, I will forward it to our development team.
You can't use this option out-of-the-box, but there's a way to do it.
You need to open this file: ../wp-content/plugins/wpdatatables/templates/admin/table-settings/table_settings_block.inc.php and around line 335 you'll see this:
You can replace the last option (All) with the 1000 option, like this:
And you'll have that option in the "Display" tab above the table:
Then, open ../wp-content/plugins/wpdatatables/source/class.wpdatatable.php and around line 3207, and replace "All" with 1000, so it looks like this:
And the last thing to do is to go to line 499 of the same file, and modify it so it looks like this:
So, again, replace -1 with 1000.
You may also want to add the value in ../wp-content/plugins/wpdatatables/templates/admin/table-settings/column_settings_panel.inc.php around line 570, if you wish to add that value to possible column options (if you have a select-box filter, or selectbox editor input type, this would be the number of values displayed in those drop-downs).
Please make sure to delete cache in your browser after you apply the changes.
This removes the ALL option, but you can freely add new values in there.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables