how to use SQL Query on jira..? Do i need to install any plugin for this..?

i am new to jira, i would like to use SQL queries on jira. i dont know where i need to run SQL query

3 answers

0 votes

You've said you're on OnDemand, so you can't install plugins and you can't access the database directly.

However, if you were running your own installation, then you could use some SQL, but your question isn't really clear enough to give you an answer. Anything can run SQL against a Jira database, you'd use whatever tools you usually use to connect to one - a command line, a GUI, whatever.

So, the question is really "what are you trying to do", even before you think about doing it with SQL.

Of course you should never WRITE to a Jira database using SQL, you'll break Jira.

i would like to pull report using this query

SELECT temp.CALLER, jiraissue.pkey from (
SELECT * FROM os_historystep where STEP_ID=5 order by FINISH_DATE desc
) as temp left join jiraissue on jiraissue.ID = temp.ENTRY_ID
group by temp.ENTRY_ID order by temp.FINISH_DATE desc;
i dont know where to run this query

Hi Selvaa,

Kindly raise a support ticket for your query for us to continue data gathering in your instance. :)

https://support.atlassian.com

Cheers,

Justin.

Hi Selvaa,

Kindly raise a support ticket for your query for us to continue data gathering in your instance. :)

https://support.atlassian.com

Cheers,

Justin.

do i need to raise support ticket for each and every query..?

Probably - you're trying to run arbitrary SQL, and I think Atlassian are trying to get at the same question I asked, and you didn't answer - "What are you trying to do"?

What's the report, the requirement? What are you looking for? What's the question you are trying to answer here?

Ok, you'll definitely need to raise that with Atlassian's OnDemand support.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

469 views 7 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you