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.
Wow amazingly fast reply !
I actually found a very useful built-in function in JQL that allows this.
filter = "Active Issues where currentUser in summary, description, comments"
OR filter = "Active Issues where Participant = Current User"
OR filter = "Active issues where Watcher = Current User"
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs