Yes, I am aware of this but I mean to LIMIT in MySql the total amount of records. I used the LIMIT on the backend in the database and it does limit the total amount of records on the backend but it does not stick and does not work on the wpdatatable. What you are talking about only limits the amount of records per page not the amount in total. If this is not possible, this is something you should offer in the future.
That answered my question. I created a view but then could not make changes which I need to make so I can't use LIMIT. Thanks for confirming this for me.
How to Limit rows in a table or how to only allow ten records to be seen by the viewer.
Hello John
Thank you for your purchase.
You can change this in the "Display" tab above the table, under "Default rows per page":
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
Yes, I am aware of this but I mean to LIMIT in MySql the total amount of records. I used the LIMIT on the backend in the database and it does limit the total amount of records on the backend but it does not stick and does not work on the wpdatatable. What you are talking about only limits the amount of records per page not the amount in total. If this is not possible, this is something you should offer in the future.
Hi again John
wpDataTables adds LIMIT automatically and it will be overridden by table settings.
If you need to use LIMIT, you will need to disable server-side processing, in which case you won't be able to edit the table.
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
That answered my question. I created a view but then could not make changes which I need to make so I can't use LIMIT. Thanks for confirming this for me.
You're welcome, John.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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