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
Next: Root
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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi All
I please need your help :)
I have 2 projects :
I need a JQL query so i can list all items (Epic, story, sub-task) in project B for which the Epics are linked to the initiatives located in Project A.
Please help:)))
PS : I don't have any pluggin... and I'm not allowed to put one in my work station., I need a basic JQL query with no fancy tools 😜
Hey @Martin Bayer _MoroSystems_ s_r_o__ ,
You could well be right.... however, because @Exalya has mentioned that they are using Initiatives and has posted in the Advanced Roadmaps space then I had assumed that they have Advanced Roadmaps (either as an app on server, bundled with Data Center or on Cloud) but this might not be the case and you're right that we don't know this for certain.
However, assuming @Exalya does have Advanced Roadmaps then my solution should work - especially assuming that she has created Initiatives as a hierarchy level above epic..... hopefully they'll be able to clarify this,
Regards,
Dave
Hi @Exalya ,
You can use the "portfolioChildIssuesOf" function, for example you'd write JQL like this:
issuekey in portfolioChildIssuesOf(INI-3) AND project = "Project B"
Despite the name, this function actually returns all descendants of the issue provided - not just the children.
This particular example just fetches the children of a specific initiative so you might need to have OR conditions if you want to fetch the descendants of multiple initiatives.
However, it is important to note that this is an expensive query to run in terms of computation so can take longer to run than other queries.
I hope this helps!
Regards,
Dave
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello thank you for the answer 😇!!
tjis still doesn’t help tho because I want all initiatives not only
in portfolioChildIssuesOf(INI-3)
Because this request returns only for one initiative, I want all issues ( in project B) that have a link to all initiatives (in project A).
please help
Thanks in advance 😇
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunately I don't that there's a simple JQL solution for this @Exalya .... the only thing I can think is that you could create an additional hierarchy level above Initiative and then make it a parent of all the Initiatives in Project A and then use the portfolioChildIssuesOf for that issue. That's definitely a workaround to the problem but it should at least work.
Regards,
Dave
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, I'm sorry, you are right, I didn't notice it is for Advanced Roadmaps :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Exactly!! Yes we do have a SAFe framework .. and projects setup as portfolio.
Does this help 🙏🙏.
Thank you so much
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.