We have a requirement where we need to combine the results of multiple filters/jql's into a single report.
Is there a plugin available for the same? Could anyone please suggest how could we achieve this?
Unfortunately, this plugin won't help. Allow me to explain it further, suppose I have written one JQL for a jira project 'TEST One'.
eg. project = TO and issuetype = "Bug"
and another jql for another project 'Test Two'
eg. project = TT and issuetype = "Bug"
I want the results for both JQL's in a single report in Jira. Can I use a join?
The SQL for JIRA plugin is able to achieve it seamlessly as it fully supports JQL integrated with SQL. The SQL language supports the UNIION command for that. Ex:
select * from ISSUES where JQL = 'project = TO and issuetype = Bug' union select * from ISSUES where JQL = 'project = TT and issuetype = Bug'
alternatively you might want to combine both JQL queries within a single one only:
select * from ISSUES where JQL = '(project = TO and issuetype = Bug) OR (project = TT and issuetype = Bug)'
both queries would provide the same result data.
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