Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira database

Archana December 5, 2019

Hello,

 

How do I access the Jira database for reporting.

Is it a SQL or MySQL programming language?

 

Thank you.

3 answers

1 vote
Jack Brickey
Community Champion
December 5, 2019

It appears you are on Cloud I’m which case you cannot access. 

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 7, 2019

If you were on server, it's quite simply standard SQL - "MySQL" is SQL, as is Oracle SQL, PostGreSQL, MS-SQL and the others.  (Yes, some of the usage varies, like line endings, cases, server commands etc, but the definition of SQL does not include them.  "Select * from X where Y" works across all SQL based databases)

But you said Cloud, so you can forget it.  You have no access to the underlying database on Cloud, you'll need to work over the REST API.  That only allows the use of JQL, not SQL.

0 votes
Joe Pitt
Community Champion
December 5, 2019

You need to contact the DBA who set it up. JIRA supports many database. JIRA doesn't provide access to the database except through the UI. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events