Find all issues underneath an Initiative

[Robert Nadon]

I have a DC customer that need to find all children underneath an initiative in Advanced Roadmaps that satisfy a query.  I have done this in cloud but cannot find a solution for DC.  I did find a way to do it where I supply a key, but I need to supply a query.

For example something like:

issue in childrenOf('projectCode ~ 2024') 

or something along those lines.

According to docs I have found Scriptrunner says they do it but it does not work.  Also I have not been able to get JQL Search Extensions to work either.

Willing to test plugins or any solution at this point.

Thanks in advance...

[Florian Bonniec · Accepted solution]

Hi @Robert Nadon 

I'm using this query from Scriptrunner on my side.

Portfolio

Regards

[Robert Nadon]

Hi @Florian BonniecI had found and tried that and this is what I got.  Both times not found.    Scriptrunner is installed.   What am I missing?!?  I am Jira-admin.

[Robert Nadon]

Scratch that Scriptrunner was disabled.    My mistake.  Thanks!

[Florian Bonniec]

Do you manage to find the field issueFunction in the custom field list ?

It should be listed and tag as locked. No one should be able to delete it but in some past experiences admins removed it from the database directly. 

The second JQL is correct.

[Florian Bonniec]

You may need to add OR issueFunction in issuesInEpics("issueFunction in portfolioChildrenOf(\"status = 'to do'\") ")

[Dick]

Hi @Robert Nadon 

DC sorely misses the foreach function in automation. It can only be mimicked somewhat by "doing the required stuff" when an issue is updated (and a proper initiation to all relevant tickets beforehand). 

Dick