i am new to jira, i would like to use SQL queries on jira. i dont know where i need to run SQL query
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.
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.
i would like to pull report using this query
SELECT
temp
.CALLER, jiraissue.pkey
from
(
*
FROM
os_historystep
where
STEP_ID=5
order
by
FINISH_DATE
desc
)
as
left
join
jiraissue
on
jiraissue.ID =
.ENTRY_ID
group
.FINISH_DATE
;
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?
i got the below link from my TL he is asking me how to use this query on jira: This is my requirement
https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-Listusername,fullname,emailaddress,logincount,andlasttimeloggedin
Ok, you'll definitely need to raise that with Atlassian's OnDemand support.
It looks like you're new here. Sign in or register to get started.
