silreporting_transposeTable

Syntax

silreporting_transposeTable(silTable[, transposedHeaders])

Description

Transpose the specified table.

Parameters

Parameter name	Type	Required	Description
silTabel	SILReportingTable	Yes	The table to be transposed.
transposedHeaders	SILReportingHeader []	No	List of headers that should be displayed for the transposed table.

Return type

SILReportingTable

The transposed table.

Example

In the fallowing example you can see a transposed 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;


SILReportingHeader [] transposedHeaders;
for(string p in projects){
    SILReportingHeader h;
    h.name = p;
    h.sortable = "sortable";
    transposedHeaders += h;
}

return silreporting_transposeTable(table, transposedHeaders);