silreporting_sumTable

Owned by Ana Gologan (Deactivated)
Last updated: Jun 28, 2019
1 min read

Syntax

silreporting_sumTable(silTable)

Description

Calculates the sum per columns for a provided table.

Parameters

Parameter name

Type

Required

Description

silTabel

SILReportingTable

Yes

The table.

Return type

SILReportingTable

The table with the sum calculated in the footer.

Example

In the fallowing example you can see the sum per columns for a table which contains the number of opened and resolved issues for a list of projects.

string [] projects = "TEST|FIBR|STEI|GRBI|HGES|RGIS";
string [] resolvedIssues;
string [] openedIssues;
for(string p in projects) {
    resolvedIssues[p] += countIssues("project = " + p  + " AND status in (Done, Closed, Resolved)");
    openedIssues[p] += countIssues("project = " + p  + " AND status not in (Done, Closed, Resolved)");
}
    
SILReportingHeader [] headers;

SILReportingHeader h1;
h1.name = "Opened Issues";
h1.sortable = "sortable";
headers += h1;
    
SILReportingHeader h2;
h2.name = "Resolved Issues";
h2.sortable = "sortable";
headers += h2;

string [][] rows;
for(string p in projects){
    rows += {openedIssues[p], resolvedIssues[p]};
}

SILReportingTable table;
table.headers = headers;
table.rows = rows;

return silreporting_sumTable(table);