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.