Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL HELP : 2 projects linked by initiative to Epic

Hi All

I please need your help :)

I have 2 projects :

  • Project A : has all the initiatives
  • Project B : has all the Epics linked to the initiative of Project B

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:)))

3B22FF61-7538-4504-875C-2F468889DB60.png

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 😜

 

4 answers

1 vote
Dave Atlassian Team Mar 04, 2021

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

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 😇

Like Dave likes this
Dave Atlassian Team Mar 04, 2021

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

1 vote
Dave Atlassian Team Mar 04, 2021

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

Exactly!! Yes we do have a SAFe framework .. and projects setup as portfolio.

Does  this help 🙏🙏. 
Thank you so much 

Hi, I'm sorry, you are right, I didn't notice it is for Advanced Roadmaps :(

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

⚡️NEW Group for Confluence Cloud Admins

Calling all Confluence Cloud Admins!  We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...

109 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you