I have installed SQL driver for JIRA and now I am able to perform advanced search using SQL.
Both questions seems to be related and are supported in SQL for JIRA Driver
Staring with your second question, the short answer is YES.
The ISSUES table has a special column named JQL. You have to use it as input to populate the ISSUES table with the data. Example, you might want to get your reported issues which have generated certain amount of debate/comments with threshold 5 (at least 5 comments)
select i.key as "Issue", count(*) as "Comments" from issues i inner join issuecomments c on c.issueid=i.id where i.jql='reporter=currentUser()' group by i.key having count(*) >= 5
copy and paste the query above in the SQL console and perform it to see the results.
In regard of your first question, any SQL for JIRA query can be converted back into a JQL by using the built-in sql predicate. Example:
issues in sql(" select i.key from issues i inner join issuecomments c on c.issueid=i.id where i.jql='reporter=currentUser()' group by i.key having count(*) >= 5 ")
The JQL above can be saved as JIRA filter: "Top commented issues" and the use it as any other regular saved filter in JQL by using the filter keyword:
filter="Top commented issues"
Thank you very much Pablo,
but when I run
in issue navigator I get
Field 'issues' does not exist or you do not have permission to view it.
What is wrong?
Thanks in advance,
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot