| 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+%28Table+Report%29+-+15482458 |
|---|
| width | auto |
|---|
|
This particular example will generate a table report showing the number of opened issues vs number of resolved issues for a given list of projects.
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; // the hearders of the table
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; // populating the rows
for (string p in projects){
rows += {openedIssues[p], resolvedIssues[p]};
}
SILReportingTable table;
table.headers = headers;
table.rows = rows;
return table;
|
...
| Info |
|---|
For more information about the predefined structures that comes in help for the table reports check the predefined structure types page. |