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.
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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