Query to filter all the Epics in a project that has child issues

[Ujjwal Jayswal]

Am using the Jira cloud

I have a Project = Alpha 

the project has 6 Epics 

4 Epics each have 2 stories

2 Epics don't have any stories 

I want to filter all the Epics with Stories and. Epics without stories irrespective of the status of the stories. 

[Trudy Claspill]

Hello @Ujjwal Jayswal 

Welcome to the Atlassian community.

With only native Jira filter capabilities it is not possible to filter for Epics based on whether or not they have child issues.

There are third party apps that add functionality that would enable you to do this. You can investigate the options in the Atlassian Marketplace. Here is a search to help you get started:

https://marketplace.atlassian.com/search?query=jql&product=jira&hosting=cloud

Do you already have any of these apps available in your Jira instance? Are you willing to consider an app?

What do you want to do with the results of the search? It may be possible to get the list through an Automation Rule, through which you could email the results to specified recipients.

Another work around would be

1. Create a custom field to keep track of the count of child issues, and add the field to the Epic issues.
2. Create Automation Rule(s) to update that field as new child issues are added or child issues are removed from an Epic.
3. Build your filter based on that custom field.

[Trudy Claspill]

Hello @Ujjwal Jayswal 

Were you able to meet your needs with the information we provided in our responses? If so, please consider clicking on the Accept Answer button above the useful responses, which will mark your Question as Solved.

[Varsha Joshi]

Hi @Ujjwal Jayswal 

Welcome to the community! 

I do not think you can query to pull epics that have linked issues(stories). 

You could pull epics and stories by using the below JQL

project = ATestProject AND issuetype IN ( Epic, Story)

Hope this helps.

Thanks

Varsha