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
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.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot