Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Export JIRA portfolio data from database

Heshan Manamperi
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 7, 2018

Is any one know how to export following data directly from JIRA db. These are portfolio data. 

column I requires in output of db query is:
-User's Name
-weekly hours
-Team name
-Plan name
-Team velocity

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 7, 2018

That would take days to work out, probably.  Using the database for reporting in Jira is the single worst possible option.  It is not designed for reporting at all, it is a data store and hence even the most simple questions you think might be easy in SQL are a nightmare.

I'd suggest you have a look at the reports and reporting add-ons in the marketplace.

Suggest an answer

Log in or Sign up to answer