Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How do i get a list of issues that are grandchildren/great-grandchildren, etc...


Is there a JQL that will give me a list of issues that are grandchildren (and therefore have grandparents)  ?

For example, if:

  1) prj-A has a parent prj-B (B is the "Master bug id" of A) and prj-B has parent prj-C (C is the "Master bug id" of B)

  2) prj-X has a parent prj-Y (Y is the "Master bug id" of X) and prj-Y has parent prj-Z (Z is the "Master bug id" of Y)

i would like the jql to return prj-A and prj-X



2 answers

"issuekey in portfolioChildIssuesOf(XXX-123)" <- where "XXX-123" is the key of your parent/grandparent

0 votes
Alexey Matveev
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.
Jan 08, 2018


It is no possible out of the box. You should use an add-on for it. There are a few add-ons available in the marketplace (Power Scripts, Adaptivist Scriptrunner).  If you are on Jira Server/ Data Center you could use Power Scripts add-on. You could write your own JQL function which would cover all your requirement and then you could use this JQL function in JQL queries.

If you need assistance with such a script, I could help you.

I have Adaptivist Scriprunner installed.

It looks like i can use the "linkedIssuesOfRecursive()" function

Thanks for you help.

Suggest an answer

Log in or Sign up to answer