Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,723
Community Members
 
Community Events
168
Community Groups

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

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

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

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

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

Atlassian Community Events