...
...
...
...
...
...
...
...
...
...
...
...
...
...
Button handy |
---|
blank | true |
---|
color | #0052CC |
---|
name | Send Feedback |
---|
link | https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=Opened+vs+Resolved+Issues+Report+Transposed+-+15482454 |
---|
width | auto |
---|
|
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.