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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...
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