Trying to filter child epics/issues by custom field - need some JQL help please

Nick Wilsdon February 27, 2024

Hi,

I have created a new tier - Initiatives - and we have set a custom field across all Initiatives/Epics/Issues as "Target Quarter", i.e., Q124. We are using the Hierarchy for Jira plugin to help us set up this Initiative/Epic relationship. 

I can filter on Target Quarter, using the following:

issuetype=Initiative AND "Target Quarter[Select List (multiple choices)]"=Q124

However, this will also return child epics/issues that can have their Target Quarter set to Q224. It keeps the hierarchy but doesn't carry down the filter condition of Target Quarter. 

Is it possible to have the filter requirement of "Target Quarter = Q124" applied at all levels of the hierarchy in the returned results? 

Thanks for your help

1 answer

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 27, 2024

Hi Nick - Welcome to the Atlassian Community!

That makes no since that it would not limit the results to Q124. Can you share a screenshot of the filter with the results? 

Nick Wilsdon February 27, 2024

Thanks for the welcome John. Sorry, I'm probably not explaining the problem very well. Hopefully this screenshot does a better job. We're essentially trying to _only_ see Initiatives/Epics/Issues that have been marked up as "Target Quarter" Q124. 

This is within the "Hierarchy for Jira" screen as we wanted to roll up story points and progress, but I suspect the issue is more around my lack of understanding of JQL. 

Screenshot 2024-02-27 at 14.29.26.png

Nick Wilsdon February 27, 2024

Screenshot 2024-02-27 at 14.33.16.png

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 29, 2024

Seems like I remember there was a bug for Team-managed projects with a query like this. Is this a Team-managed project? 

Nick Wilsdon February 29, 2024

This is a company managed project. It does seem odd that the filter doesn't work on each hierarchy level. I'll raise it with the Jira for Hierachy team and see if they can shine some light on this - maybe it it plugin specific. Thanks for helping though - if only to let me know I haven't missed something obvious! :) 

Like John Funk likes this
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 29, 2024

Okay - let us know how it goes here when you find out. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events