JIRA Project - How/Where can I extract the issues data for custom report use?

Question

Hi all,

Our team currently is using JIRA for project management, we created project and issues to track our tasks and progress.

Now we want to know if there is any way we can extract the backend data, then we can use the data to do some complicate analysis or report. For example, we want to get the average execution time of each kinds of activities/transactions for the entire project, please refer to the screenshot I attached here. Is the JIRA has built in report or template that can achieve this? But so far I only see those built in report/dashboard are all on Issue's level, cannot go to the activities/transactions level.

So is there any API/Interface in JIRA that I can write code(.net/java/SQL) to connect to the backend database to extract the data for our custom reporting? If yes, who to contact and what kind of permission I need to request?

Thanks,

Edward

edward huang_w2osu9 · Answer

Thank you Nikki, will check them.

Nikki Zavadska _Appfire_ · Answer

Also @edward huang ,

if you're looking for custom reporting maybe instead of extracting data you can check if there is any plugin that will help your use case. That way you won't need to maintain your custom solution.

Some of the analytics plugins for Jira Cloud I found are:
Custom Charts and Reports
EazyBi 
Performance objectives
Simple custom reports and charts

Nikki Zavadska _Appfire_ · Answer

Hi @edward huang ,

to answer the last question. You don't have direct access to Jira database.

However, you can extract data using cloud APIs https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/

For example, this get issue that matches JQL API might be handy for your analytics but there is so many more. And if you would need it here is a doc on how to do a basic authentification for REST Jira Cloud APIs.

I hope this helps at least a little bit,

Nikki