Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.