How can I read issue details and run customer queries like in Jiradb after cloud

afra_Zhao August 8, 2022

We are using the server version now and query some customized reports via JiraDB.

Can we migrate our current DB and reports to the cloud and access our issue data on the cloud by any add-on or API? thanks.

2 answers

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 9, 2022

I'm glad to say that Cloud does not allow you any access to the database.  This is a good thing because SQL is the single worst possible way to do any reporting on Jira.

You will need to rebuild your reports using sensible methods of reading the data.  Ideally look at adding reporting apps to your Cloud system, but if you want to do it yourself, look at the connector apps for reporting tools, or build one yourself (the apps work off the REST API, and you can too)

0 votes
Kristján Geir Mathiesen
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 8, 2022

Hi @afra_Zhao 

Not sure what kind of reports you are after but you can view do API calls in the cloud. For example:

See number of issues on the instance ->

https://[name of your instance].atlassian.net/rest/api/2/search?jql=&fields=*none"&maxResults=0
See all the custom fields and values on a certain ticket -> https://[name of you instance].atlassian.net/rest/api/2/issue/[ticket id, like IT-1]?expand=names
Hope that helps,
KGM
afra_Zhao August 8, 2022

We have JiraDB when we use the Jira server version, and we query items via SQL, it seems we can no longer use this after migrating to the cloud...

by the way, how about the reports and dashboards we designed on the Jira server? can we migrate them and continue to use or optimize them? thanks.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events