JIRA Query to SQL Query

Question

Is there any way to convert JIRA query to SQL server query?

Answer 1

Hi @Hema Ramachandran ,

Welcome to Microsoft Q&A!
Here is a similar thread about Convert JQL to SQL: https://community.atlassian.com/t5/Jira-questions/Convert-JQL-to-SQL/qaq-p/890415
Please see this about SQL+JQL Driver: https://bigbrassband.com/app-integrations/sql-jql-driver.html
Hope this could give you some help.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Users usually do not have access to query the JIRA database directly.

If it is a one time query, it is much easier to use JIRA and export the results.

Answer 3

Hi Tom

Actually we can write some filter strings like
' AND issuetype in (Bug, "External Bug (CP)")
AND status in ("In Progress", "To Do", Verification, "To Fix")
AND issuetype in (Bug, "External Bug (CP)")
AND status not in ("To Do", Done, Rejected) '

How can we convert this string to SQL format?
I have a data warehouse which is populated with jira data. I need to create some custom functions, where I would like to use this converted query.