Jira - find all child issues of an issue

[Gavin]

Hi,

I have an issue MDC-27 which has a child issue of MDC-76.  How do I JQL all the child issues of MDC-27

when I try to use issuekey in childIssuesOf("MDC-27")  no results

[Gavin · Accepted solution]

The answer was 

issue in linkedIssues("DMC-24","is a parent of")

[Ismael Jimoh]

Hi @Gavin 

If you have scriptrunner, you can do a search for sub task of as explained here: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issue_links

Regards

[Gavin]

Is there anyway to do this natively just in case I don't have scriptrunner installed?

waiting on word from admins

[Ismael Jimoh]

Try parent = <parent issue key>

[Gavin]

tried that but got nothing came back.

[Gavin]

project = XYZ AND issueLinkType = "is a child of"

this at least gets the result in there but it also includes other Childs from other issues.  how can I specify just the child for the issue I'm interested in

[Nic Brough _Adaptavist_]

"parent = MDC-27"

Should return values for "I have an issue MDC-27 which has a child issue of MDC-76.", including MDC-76

If this is not working then I would want to question your definition of "child issue" - do you really mean parent/child (better explained by the Jira-speak issue/sub-task description) or are you looking at Epic links or Issue links (which are not parent/child)?

[Gavin]

Thanks for the response.  I tried that but nothing came back.

[Gavin]

So my understanding:

MDC-27 - in this issue there is a Issue link section.  Under that second it says is a parent of and MDC-76 is listed there.

MDC-76 - in the same location under is a child of and MDC-27 is listed there.

Hope that helps.

[Nic Brough _Adaptavist_]

Yep, that explains it.  

MDC-76 is not a child of MDC-27, it has a link (which your admins have mis-lead you slightly by describing it as "is parent of" and "is child of" - they are not parent/child at all)

Anyway, you should be able to get the issues that are linked to it with

linkedissue(MDC-27, "is parent of"). 

(Or possibly "is child of", I'm not 100% sure which way round it works from memory)

[Gavin]

Thanks for your patience and help. It's greatly appreciated. 

So when I enter the 

• linkedissue = (MDC-27, "is parent of") I get "Field 'linkedissue' does not exist or you do not have permission to view it."
  • however when I enter the text it shows with a green indicator and the "child" accessible as shared above.  I can manually find them or click them.

[Nic Brough _Adaptavist_]

That's very odd - could you try a quick test?  Go to search, pick advanced, and start typing the query?  Does "linkedissue" become automatically suggested?

[Gavin]

linkedissue doesn't become automatically suggested and linkedissue shows a red exclamation point but when I put linkedissue = (MDC-27, "is parent of") it puts green check mark.

[Gavin]

also as I start typing it auto suggests operators and then if you enter a value the exclamation turns to a checkmark.