You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Current »
Another feature that comes out of the box with the help of silreporting_transposeTable routine is the ability to transpose the table adn add custom headers after performing the operation.
string [] projects = argv[ 0 ];
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" ;
h1.color = "white" ;
h1.bgColor = "#79aadb" ;
headers += h1;
SILReportingHeader h2;
h2.name = "Resolved Issues" ;
h2.sortable = "sortable" ;
h2.color = "white" ;
h2.bgColor = "#79aadb" ;
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" ;
h.color = "white" ;
h.bgColor= "#79aadb" ;
transposedHeaders += h;
}
table = silreporting_transposeTable(table, transposedHeaders);
return table;
|
Now you can see all the projects and the issues that are in Opened status and Resolved status but as a transposed table.