Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How to query all Epics, Story using SQL in JIRA Cloud

Camilo Garma
Camilo Garma April 20, 2021

I have exported all tables from JIRA Cloud using Database Exporter for JIRA Cloud.

 

Can you provide a sample SQL query to get all Epics, Storys, etc from the tables

Answer
Watch
Like Be the first to like this
403 views

2 answers

0 votes
Nic Brough -Adaptavist-
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.
Become a leader
April 21, 2021

You do not.

You have no access to the database behind your Cloud system.

There are some apps that export a lot of data from Cloud and can push it into another database, and there are plenty of reporting apps in the marketplace, and there is also a "data lake" in early access, but you'll not get direct SQL access to Cloud.

View More Comments
Camilo Garma
Camilo Garma April 21, 2021

As I mentioned in my post. I exported the JIRA tables using JIRA Cloud using Database Exporter for JIRA Cloud. Hence I have access to the data in my own database.

Like
Reply
0 votes
Gonchik Tsymzhitov
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
April 21, 2021

Hi! 

Looks like you need to create request to vendor of app

https://marketplace.atlassian.com/apps/1221074/database-exporter-for-jira-cloud?hosting=cloud&tab=support

View More Comments
Gonchik Tsymzhitov
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
April 21, 2021

@Camilo Garma Could you share the structure of your DB?

Like
Reply

Suggest an answer

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

Atlassian Community Events

    See all events