field in databasetabel

[joris_monten_cegeka_com]

Hi all,

we're currently working on the renewall of our reporting services. This with PowerBI, to connect our ticketing database with Jira database.

In the report I want to get the ticket information, the svf-number, status and fix Version/s

I'm able to link everything except the Fix Versions/s field, I've found a table Jirafixversion but this isn't linkable to the Jiraissue tabel.

Does anyone have a clou where to find this?

Thanks!

[Mohamed Benziane]

Hi,

Take a look at this page you may find something to start with

https://confluence.atlassian.com/display/JIRA041/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindFixedForversionsforanissue