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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.