Row grouping is a premium feature which allows plugin users to group row data.
Inline demo server-side row grouping #
| Product line | Product ID | Product name | Vendor | Stock | Price | Retail price | Description |
|---|---|---|---|---|---|---|---|
| Product line | Product ID | Product name | Vendor | Stock | Price | Retail price | Description |
Enable row grouping #
With WP Data Access premium installed option rowGroup is available from advanced table options which adds row grouping to a data table. Additional row grouping options…
The endRender function of the example above calls javascript function code_manager_row_grouping_demo. This function needs to be added to the page using a plugin like the Code Manager.
Advanced options to add row grouping
{
"rowGroup": {
"dataSrc": 0,
"endRender": "function ( rows, group ) { return code_manager_row_grouping_demo(rows, group) }"
}
}Advanced options to add row grouping
function code_manager_row_grouping_demo(rows, group) {
var avgInStock = rows.data().pluck(4).reduce( function (a, b) { return parseFloat(a) + parseFloat(b); } ) / rows.count();
var avgPrice = rows.data().pluck(5).reduce( function (a, b) { return parseFloat(a) + parseFloat(b); } ) / rows.count();
avgPrice = jQuery.fn.dataTable.render.number('.', ',', 2, '$').display( avgPrice );
var avgRetailPrice = rows.data().pluck(6).reduce( function (a, b) { return parseFloat(a) + parseFloat(b); } ) / rows.count();
avgRetailPrice = jQuery.fn.dataTable.render.number('.', ',', 2, '$').display( avgRetailPrice );
//return "Average for " + group + ": " + Math.floor(avgInStock) + " : " + avgPrice + " : " + avgRetailPrice;
return jQuery('<tr/>')
.append('<td colspan="4">Averages for '+group+'</td>' )
.append('<td class="quantityInStock">'+Math.floor(avgInStock)+'</td>')
.append('<td class="buyPrice">'+avgPrice+'</td>')
.append('<td class="MSRP">'+avgRetailPrice+'</td>');
}Limitations #
Inline demo client-side row grouping #
| Product line | Product ID | Product name | Vendor | Stock | Price | Retail price | Description |
|---|---|---|---|---|---|---|---|
| Product line | Product ID | Product name | Vendor | Stock | Price | Retail price | Description |