I promise I've spent a lot of time searching and just can't seem to find the answer.
I need to create an Jira filter that will return back a list of Story tickets IF a custom field has been selected on an epic. Which basically is a 2 part query..
As you can see below, achieving #1 is pretty easy, it returned back 13 epics since that custom field is only available on epic tickets.
But what I now need and am really after is, if those selections above (Both, Test) are selected, then return back all the stories within those epics which have those selection. So instead of returning 13 results, I should get something like 50+ or whatever the total number of tickets is in all of the epics.
There is where I fall down completely.
Welcome to the community.
Jira doesn't natively support using the output of one filter as the input to constrain a second filter. That functionality can be found in apps that are available in the Atlassian Marketplace. Adaptavist Scriptrunner is one such app, but provides much more than just the functionality you need. Another such app is Enhanced Search (JQL & Subqueries)
There may be others. I used Adaptavist Scriptrunner in the past. I've not used Enhanced Search.
Alternately, you could write your own code to use the Jira REST API to execute the query, then parse the output to make the second query with the list of returned Epic Issue Keys and then run the second query.
Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events