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.
It looks like you're new here. Sign in or register to get started.
