I'm trying to create a JQL which will easily help us filter out all stories and subtasks with a custome field "Stream" which are are using for our project. There are 4 different teams working on the same product and we're looking for effective ways to filter out our active sprint stories. The query we're currently using is:
project = ProjectName AND Stream = S1 ORDER BY Rank ASC
It does the job when it comes to stories, but at the same time it filters out all sub-tasks which don't use this field. Of course, we could try adding this field and ensure it's added to each sub-tasks as well and I think that would do the trick? However, I was curious if there is any other JQL which would allow me to ensure if filters stories and sub-tasks for only our stream without adding a "Stream" field to sub-task issuetype. The solution which works on a project or a board level is welcome.
Thanks a lot
Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:
1) Query for issues having a given value or their subtasks
( type = Story AND project = ProjectName AND Stream = S1 ) OR ( issue IN subtasksOf(' type = Story AND project = ProjectName AND Stream = S1 ') ) ORDER BY Rank ASC
(*) Note that this is just an example, you must tune above query to fit your needs.
Using this app you can also query other issues relations, check:
Have you been looking for a solution to easily create Confluence pages directly from a Jira Cloud issue? The no code solution is here with the brand new app Elements Publish to Confluence, which work...
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