Versions Compared

Key

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

Right click on the Data Sets element in the Data Explorer view and name it Reported Issues:


Image Added

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:

Image Added

Or you might want to write it from the SQL fro JIRA Driver console (recommend for complex SQL queries or beginner users):


Image Added

Use please the following SQL for JIRA quey:


Code Block
languagesql
themeEclipse

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:

Image Added

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.

Image Added


JIRA data can also be explored at real time in the Preview Results:

Image Added

Finally click on the OK button to create the Data Set on the BIRT report:

Image Added