New RowsGroup plugin: merge cells vertically (rowspan)

tangerine

This thread is specifically concerned with the RowGroup feature. Is that what you need?

jithinwilfred

Is it possible to group based on data attribute (such as data-group="subgroup1") like that.
My requirement is to hide the group data on data attribute and show a different text on table cell, thanks

colin

No, HTML5 data attributes aren't currently supported.

joseph123

Hi
How to add border after merged row completed

allan

Is it possible to group based on data attribute (such as data-group="subgroup1")

Would you have an attribute per cell? Or per row. Either way, at the moment it isn't possible, but it something like something that might be worth exploring as an option if you could provide more information about how to plan to use it. Until then, you'd need to use rowGroup.dataSrc to point to somewhere in the data source object that contains the grouping information.

How to add border after merged row completed

Can you show me a mock up picture of what you mean please?

Allan

BhavinBhatt

It works like a charm.
But there's one issue.
I am using rowGroup also to summarize group totals at the bottom.
the issue is in endRender function of rowGroup.
It puts <td> of totals with colspan twice when the page loads first time..
Please help me out.
Example:

$('#myTable').DataTable
(
               [bla bla bla]
               rowsGroup:[0,1],
               rowGroup: 
                               {
                                         startRender:null,
                                         endRender:function(rows,group)
                                         {
var tQty = rows
                                                            .data()
                                                            .pluck(3)
                                                            .reduce(function (a, b) 
                                                             {
                                                                return a + b.replace(/[^\d]/g, '') * 1;
                                                            }, 0) ;

                                                        
                                                            return $('<tr/>')
                                                                .append('<td colspan="3" align="left" class="grpApplied" >' + group + '- Total: ' + '</td>')
                                                                .append('<td align="right">' + tQty + '</td>')
                                         }
                               },
dataSrc:[0]
); 

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin

BhavinBhatt

when page loads first time, it shows two rows of totals comes because of endRender.
when User Searches, it shows only once.

Freda

Thank you for sharing. This is very helpful for me.

jc0814

works perfectly ！ thanks ！