Versions Compared

Key

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

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.