Two SharePoint List data Need to put Row grouping in Datatable

NagarajanE

Hi Team,

I have below datatable. From this table i want to do row grouping.

I have to take Title column and should start the grouping. But the first value of the row should be a header remaining rows should come as grouping.

In this table wtihout ">" are coming from List 1. And with ">" values are coming from list 2. Now i want to perform groupingg based on title but grouping should be apply only on ">".

Please help me on this.
Current Datatable:
Title Comments
12344 Demo policy data
12344 Demo data for 12344
12344 Test data for 12344
12344 Tested data for 123443
12345 TestPolicy1
12345 Test data 12345
12345 Demo data
12345 Test record added
12346 12346 data
12347 Test data added
Showing 1 to 10 of 10 entriesPrevious1Next

Actual Table I am expecting:
Title Comments
12344 Demo policy data

12344 Demo data for 12344
12344 Test data for 12344
12344 Tested data for 123443
12345 TestPolicy1
12345 Test data 12345
12345 Demo data
12345 Test record added
12346 12346 data
12347 Test data added
Showing 1 to 10 of 10 entriesPrevious1Next
Code:
$pnp.sp.web.lists.getByTitle("TestPolicyNo").items.select("Title","PolicyName").top(5000).get().then(function(results) {
var uniquepolicynumber= new Set();
for (var i = 0; i < results.length; i++)
{
dataTable = $("#table_id").DataTable();
dataTable.row.add([results[i].Title,results[i].PolicyName]).draw(false);
$pnp.sp.web.lists.getByTitle("Testattachment").items.select("Title","Attachmentno").top(5000).filter("Title eq '"+results[i].Title+"'").get().then(function(attachmentscount) {
for( j=0; j<attachmentscount.length;j++){
dataTable.row.add([attachmentscount[j].Title,attachmentscount[j].Attachmentno]).draw(false);
}
});
}
});
$("#table_id").dataTable({ "bLengthChange": false, "bPaginate": false}).rowGrouping({iGroupingColumnIndex: 0,
iGroupingColumnIndex2: 1,
bExpandableGrouping: true,
bExpandableGrouping2: true,
bExpandSingleGroup: false,
iExpandGroupOffset: -2,
sGroupingColumnSortDirection: "asc",
});

colin

Hi @NagarajanE ,

Have you looked at RowGroup - it sound like it should do what you're after.

Cheers,

Colin

NagarajanE

Row group cannot be performed. I am taking data from 2 different list . After that am applying grouping. So its not applying grouping.