You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I'm setting up an Advanced Roadmap.
My company has a project that houses all the Themes and Initiatives for the company, and my project has all of my team's work. I want my plan to include the themes and initiatives from the company project so we can see how our work relates to them, but including them as a source pulls in ALL of the company Themes and Initiatives, of which there are a lot. I'd like to only include the Themes and Initiatives that have children in my project to reduce the clutter in my plan.
The Themes and Initiatives need to live at the company project level as they are often shared by many teams.
I thought to try and change the issue source for the company level issues. Instead of pulling them all in, I could create a filter - but I can't seem to figure out how to write a JQL statement that would select only issues where the Initiative has a child in my project, and where the Theme is the parent of one of the previous Initiatives.
Is there a better way to do this or a JQL that will only grab the relevant Themes and Initiatives?
Hi @Ryan Elkins and welcome! If you use ScriptRunner, you can use the issueFunction in portfolioParentsOf(Subquery) function. https://docs.adaptavist.com/sr4js/8.2.1/features/jql-functions/included-jql-functions/portfolio#portfolioParentsOf
Thanks - any ideas of how this might work without a paid add-on? My org doesn't have it and I probably can't convince them to part with a chunk of money every year so I can have a cleaner roadmap for my project.
I'll just use this moment to rail against how it seems like 90% of the time I get stuck the answer is "well, if you use ScriptRunner..." It just feels like there are too many basic things that JQL can't do out of the box and requires a paid addon.