Search for all child issues based on a field value on the parent

[Inactive Stephen]

Hi All,

I'm trying to search for all issues that have a parent with a specific value in one field.

A little upfront info:

- We have Scriptrunner, Portfolio and Tempo

- Our hierarchy is Initiative > Feature > Epic > Story

- Initiatives belong to Accounts - this is managed via Tempo and not an issue type

What I'd like to do is search for all Features which have an Initiative (parent link) where the Initiative's Account field (tempo custom field) is equal to a range of Account IDs. Is that possible?

Thanks,

Ste

[Logan Clemons]

I'm essentially trying to do the same thing. Did you ever find a solution to this problem?

[Inactive Stephen]

@Logan Clemons - Yes I did!

In our specific example, the JQL we use is:

issuefunction in portfolioChildrenOf("issuetype = Initiative and Account = 'XXX'")

A few things to note:

• This JQL uses ScriptRunner
• The search at Initiative level is contained between the two double quotation marks. We use single quotations on the Account field as a double mark would be seen as closing the query.
• This provides us all the Features and Epics below an Initiative, based on our Jira Portfolio hierarchy. 

^ This was specific to our need, but there are other ways of doing this and to lower levels of your work hierarchy - for example, we use a similar approach when searching for stories. 

If this doesn't provide you sufficient information, let me know your specific problem and I'd be happy to try and help you :)

Ste