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);