...
...
...
...
...
...
...
...
...
...
...
...
...
...
We've encountered an issue exporting this macro. Please try exporting this page again later.
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; // the headers of the transposed table(if it has any business meaning otherwise it can be left empty)
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); //transposing the table
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.