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
First you need to add the SIL Reporting Gadget to your dashboard. To do that, click Add new gadget. In the Add new gadget dialog, click Load all gadgets. Search for the SIL Reporting Gadget and add it to your dashboard.
To see more instructions about adding a gadget to your dashboard see Atlassian documentation.
The configuration screen is only available to Jira Administrators and System Administrators.
To configure the gadget you have to select the sil script file and add the default values for the parameters used in the selected script.
| 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
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.
| 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;
return table; |
| Info |
|---|
For more information about the predefined structures that comes in help for the table reports check the predefined structure types page. |
Opened vs Resolved Issues Report Transposed
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.
| 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; |