Right click on the Data Sets element in the Data Explorer view and name it Reported Issues:
In next screen you have to provide a SQL for JIRA query. You can write it there directly even exploring the database schemes, tables and columns:
Or you might want to write it from the SQL fro JIRA Driver console (recommend for complex SQL queries or beginner users):
Use please the following SQL for JIRA quey:
Code Block | ||||
---|---|---|---|---|
| ||||
select
i.key as"Issue",
i.summary as "Summary",
t.name as "Type", t.url as "TypeUrl",
s.name as "Status",
c.colorname as "Status Color"
from
ISSUES i
join
ISSUETYPEDEFINITIONS t on t.id = i.typeid
join
ISSUESTATUSDEFINITIONS s on s.id = i.statusid
join
ISSUESTATUSCATEGORYDEFINITIONS c on c.id = s.categoryid
where
i.jql = 'reporter = currentUser()' |
and paste it in the BIRT report:
Click on the Finish button and explore more data set options:
Output Colums: It shows the colum Names, thier Type and the Display Name among other data. Tip: you might want to use aliases for columns in your SQL for JIRA query as it simplifies the Name and Display Name later configuration.
JIRA data can also be explored at real time in the Preview Results:
Finally click on the OK button to create the Data Set on the BIRT report: