Find all issues underneath an Initiative

Robert Nadon
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 18, 2024

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...

2 answers

1 accepted

2 votes
Answer accepted
Florian Bonniec
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 18, 2024

Hi @Robert Nadon 

 

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

Portfolio

 

Regards

Robert Nadon
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 18, 2024

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.

Screenshot 2024-11-18 at 8.58.40 AM.pngScreenshot 2024-11-18 at 8.59.00 AM.png

Robert Nadon
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 18, 2024

Scratch that Scriptrunner was disabled.    My mistake.  Thanks!

Like Florian Bonniec likes this
Florian Bonniec
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 18, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 18, 2024

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

0 votes
Dick
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 18, 2024

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

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