Skip to end of banner
Go to start of banner

Opened vs Resolved Issues Report Transposed

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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. 

  • No labels