Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Search for Advanced roadmap issues without a child

Rob Crick November 6, 2022

Any suggestions on how to search for Issues in an Advanced Roadmap hierarchy that do not have any children assigned?

 

Along the lines of the opposite of "Parent Link" IS EMPTY;  "Child Link" is empty. 

 

On Cloud version with Advanced Roadmap.

1 answer

0 votes
Trudy Claspill
Community Champion
November 14, 2022

Hello @Rob Crick 

There doesn't appear to be a native solution for this. Do you have or are you open to using a third party app to get this? Is this something you will need to do repeatedly? Do you have a large number of parent issues in the hierarchy to check?

Rob Crick November 30, 2022

@Trudy Claspill  - thx for the feedback.  The functionality would only be used by a few people in the organisation so providing the costs is not too great, yes we would look at an App.   Scriptrunner used to this for Jira Portfolio when we were on Prem 

Rob 

Trudy Claspill
Community Champion
December 1, 2022

How did you solve this with Scriptrunner and Jira Portfolio on-premise?

What do you want to do with the output, once you have it?

I think there might be a way to do this through Automation for Jira. I'm still trying to work it out. If it is possible, you could schedule the rule to run, or make it a manually triggered rule, and send email(s) with the results.

Rob Crick December 4, 2022

 

Use case 1: JQL to find the issues that don't have a parent, so effectively orphaned.  This mirrors the Advanced Roadmap view for issues without a parent link    

issueFunction not in parentsOf("project = apsmt and status not in (cancelled,done)")

 

Use case 2: same JQL but using "in" to get all issues within a parent hierarchy - used to filter out parents not associated with a project.   

Trudy Claspill
Community Champion
December 5, 2022

ScriptRunner for Jira Cloud has the same capability that you used in ScriptRunner for Jira on-prem. Are you open to getting that app for your Cloud environment?

Rob Crick December 5, 2022

we have it running but some commands are unavailable with an error saying, "Not available with next-gen projects yet!"   - so just looking for an alternative to traverse up and down parent child hierarchy within an Advanced Roadmap hierarchy "Parent Link" and Children of Epics  

Trudy Claspill
Community Champion
December 5, 2022

Oh, I see, you are working with a Team Managed project.

I was under the impression that Advanced Roadmaps did not yet work for Team Managed projects. But I don't work with Advanced Roadmaps or Team Managed projects regularly, so maybe the support has been added.

Based on this issue it seems that AR is not fully supported with Team Managed projects yet.

https://jira.atlassian.com/browse/JSWCLOUD-20012

Trudy Claspill
Community Champion
December 5, 2022

Yep, just double checked

https://www.atlassian.com/software/jira/features/roadmaps

And under the FAQ section it still says Advanced Roadmaps is not supported for Team Managed projects.

Do the different roadmaps support both Jira Software Cloud team-managed and company-managed projects?  

Advanced Roadmaps currently only works with Jira Software company-managed projects. The basic roadmaps are available in with both Jira Software team-managed and company-managed projects.

Rob Crick December 5, 2022

Interesting. 

We are only using AR with Company managed projects.  Three projects out of 100's have been set up as Team Managed projects but are not connected to an AR roadmap. 

Is there a system configuration setting that determines the whole site as Team Managed or "Next Gen" ?  

 

It seems script runner assumes all projects are next gen as I get the error when trying to use the JQL function on a Company managed project.  

Trudy Claspill
Community Champion
December 5, 2022

There is not global setting that specifies a site is Company Managed or Team Managed. That is a per project setting only.

Can you share with us the filter you are trying to use for ScriptRunner that is resulting in the error "Not available with next-gen projects yet!"? I suspect that there may be something about the filter that is not constraining it to only Company Managed projects.

Rob Crick December 5, 2022

image.png

Rob Crick December 5, 2022

Project PLV is a company managed project 

image.png

Trudy Claspill
Community Champion
December 5, 2022

I have not been able to replicate your scenario to get that message.

When I try the same query using a valid space key for a Company Managed Software project, I do not get the message.

I notice that you seem to be missing a closing parenthesis at the end of the statement. When I do that in my system then the system goes from returning some results to returning 0 results, but I still don't get the message.

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