The table report is a simple way to display your data in a table format using the Simple Issue Language™ (SIL) . SIL provides out of the box predefined structures and routines that comes in help for generating such a report.
Configuring SIL Reporting Gadget
...
| Note |
|---|
The script that you are using to generate the report needs to return the table structure that you are building otherwise the report will throw an error. |
Examples
Opened vs Resolved Issues Report
...
| Code Block |
|---|
string [] projects = "TEST|FIBR|STEI|GRBI|HGES|RGIS";
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; |
...
| Code Block |
|---|
string [] projects = "TEST|FIBR|STEI|GRBI|HGES|RGIS";
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; |
