How to get access to backend data when using JIRA cloud

Question

Hello team,

Iam using JIRA cloud and would like to get access to the database where the data related to our system is stored. for e.g. If i have to work on a report based on the history of the ticket, i would like to be able to download the entire history of the ticket and work based on the data i get. but currently i don't have the option to download the history ...I need to use some group by functions and distinct clause which JQL doesn't support,. Kindly let me know how do i access Database when using the cloud version.

Thanks and Regards

Kiranmai.

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

You have no access to the Jira database on Cloud, and never will have.

You don't want it anyway, it's the worst possible thing to look at if you want to report on Jira.  You will need to use the REST API which is far nicer to use than the database, or, if you have a premium subscription, try out the Data Lake.

Patricia Francezi_iDev_ · Answer

Hi @kiranmai c

Currently the only way to access cloud database is via Jira Enterprise - meaning you would need to upgrade your plans to it.

But there are a minimum number of users, so, not sure if this would help you.

You could try to retrive data using public API

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get

Use the expand changelog - so it will include history field.

I hope this helps