Officially jQuery DataTables doesn’t support
ROWSPAN attributes for a cell in table body. I already wrote how to use ROWSPAN attribute with jQuery DataTables. Today I am going to demonstrate a trick to use
COLSPAN attribute for HTML and Ajax sourced data.
Back in February, 2017 I wrote about unofficial row grouping plug-in for jQuery DataTables, see jQuery DataTables: Row grouping and checkboxes.
However there is also official extension for row grouping – RowGroup. It works differently than unofficial plug-in and adds a separate parent row for a group of child rows.
Past version of jQuery DataTables had column reordering plug-in ColReorderWithResize that also provided the ability to resize columns by clicking and dragging the point between two columns. However this plug-in was not compatible with the latest version of jQuery DataTables.
Luckily Jeff Walter updated ColReorderWithResize to make column reordering and resizing work with jQuery DataTables 1.10 and released it under MIT license.
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.