This is a typical problem for users just starting to use jQuery DataTables. It is caused by how it handles the table data.
jQuery DataTables distribution comes with server_processing.php script and ssp.class.php class that add support for server-side processing and better performance for datasets with more that 10,000 records. However these files need to be tweaked if your query contains
GROUP BY clauses.
If you are displaying a form in a table powered by jQuery DataTables library, you probably know it is a challenge to submit form data from all pages, not just current page. In fact this is one of the most frequently asked questions on Stack Overflow and that is why I am going to address it today.
Imagine you have filtered and sorted your data table in a certain way and want to share a link to that particular state of the table. There are some additional plug-ins that solve that problem.
Laravel DataTables adds server-side processing capabilities for a table powered by jQuery DataTables to a Laravel application. There is official site with detailed documentation and good examples. However I couldn’t find an example of using orthogonal data for sortable and searchable fields containing timestamps.