JQL

[PLohitha S]

• We have one project name Xyz 
• We have issue type initiative and under we have created a epic as a child issue 
• Under Epic we are having Stories as a child issues .they are from different project from our instance how search a JQL query for all epics and all stories 

Thanks

[Mikael Sandberg]

Hi @PLohitha S,

Welcome to Atlassian Community!

JQL out-of-the-box cannot do a nested query that would allow you to get all epics and their associated stories, unless you specify each issue key for the epic in the query. You need an app that extends JQL in order to do a nested filter. There are multiple apps in the Marketplace that can do this, I have used JQL Tricks and Enhanced Search in the past to do it. 

[Charlotte Santos -Appfire-]

Hi @PLohitha S 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all epics and stories that are children of Initiatives:

issue in childrenOfIssuesInQueryRecursive("type=Initiative")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Charlotte

[Trudy Claspill]

Hello @PLohitha S 

Welcome to the Atlassian community.

Are you using a Premium subscription? Did you set up the Issue Hierarchy and use Advanced Roadmaps to add Epics as child issues of Initiatives?

If so, there are some additional JQL fields available to you, as described here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

You can use this to get the child issues directly below the Initiative, and the child issues under those children.

 issuekey in portfolioChildIssuesOf("initiative issue key")

[Laurie Sciutti]

Hi @PLohitha S ~ I believe you can use the function, issue in (childIssuesOf(<yourinitiativeissuekeyhere>))