query all issues under an Epic(there are storys under epic and issues under storys )

[Cypher Zhong]

I want query all stories under an epic and all issues under these stories, I found `linkedIssues()` can find all stories under my epic such as:

issue in linkedIssues("example-100")

but how can I query the other issues under stories and show them all ?

[Ashkan Malekly · Accepted solution]

Hii @Cypher Zhong 

You can use this query :

project = "your project" AND issue in childIssuesOf("The key of your epic") even you can write ssue in childIssuesOf("The key of your epic")

Cheers

[Cypher Zhong]

Thanks @Ashkan Malekly 

I want use this at https://tinklabs.atlassian.net/issues/ , and it tell me:

 Unable to find JQL function 'childIssuesOf(HIG-228)'. 

should I install some plugins for this JQL function? because I haven't see it at  Advanced searching(https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-764478330.html)

[Cypher Zhong]

and I have use 'split from' to related them together, I am not using the 'add child issues'

[Ashkan Malekly]

Hi @Cypher Zhong 

I think you should set up Adaptavist ScriptRunner for JIRA for add-on

Cheers

[Cypher Zhong]

@Ashkan Malekly Thanks!  I will work on it!

[christopher.feeney]

childIssuesOf is now portfolioChildIssuesOf

[Ligia Merciu]

issue in issueInEpics("TST-1") or parent in issueInEpics("TST-1")

For issueInEpics("") function, Power Scripts for Jira is needed.

Cheers!

[Cypher Zhong]

I think I need ask my leader to add plugins XD

[JD Lobue]

Not available on the cloud?

[Ligia Merciu]

Power Scripts is availablable for cloud, too:  https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

[JD Lobue]

More plug-ins and add-ons? Ugh! Atlassian.....WAKE UP! Your product is only as good as your native software and not all these third parties software, whose compatibility with your core and other 3rd parties prove problematic.