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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 5, 2019

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

0 votes
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.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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