I am trying to find all issues that are attached to any Initiative with a certain label

patrick_sullivan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 18, 2024

He have attached PI labels to our initiatives and are trying to find a filter that will return all issues tied into those initiatives (Epics to stories to subtasks, for example). Is there a filter that can do this?

3 answers

0 votes
Prosper Agwegiokhe October 18, 2024

Hi @patrick_sullivan 

I’m Prosper, a support engineer at Appfire, and I’m here to help.

Just to compliment what @Trudy Claspill  as said, If you are open to third party apps, you can try out our App JQL Search Extension for Jira.

You can use the query

issue in childrenOfIssuesInQueryRecursive("key = {parentKey}")

to find all children issues in the hierachy level below "parentKey". You can also add other helpers functions and filter by labels as well to fit your use case.

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

0 votes
Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 18, 2024

Hi @patrick_sullivan 

 

Since you are on Premium, I'd suggest exploring portfolioChildIssuesOf() in your JQL filter.  It will return all descendants of whatever issue(s) inside the ()s.

 

 

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 18, 2024

Hello @patrick_sullivan 

Welcome to the Atlassian community.

There is not a native filter that will do that.

There is a function that can return all the issues under another issue in a hierarchy, but that works for only one issue at a time specified by issue key. You can use the portfolioChildIssuesOf() function for that.

https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/#Child-issues

Natively there is not a way to get that information for multiple issues except my using multiple criteria combined with OR:

issue in portfolioChildIssuesOf("INT-1") or issue in portfolioChildIssuesOf("INT-2")

You would have to use a separate filter to get the Initiative list for initiatives that have the Label, and then plug those issue keys into a filter like the one above.

 

There are third party apps that extend the capabilities of JQL, like ScriptRunner and JQL Tricks. Do you have any such apps, or are you willing to consider getting such an app to meet your requirement?

Suggest an answer

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

Atlassian Community Events