I need a Jira Filter to pull all Epics that only have one specific task and nothing else

[Hiram Jimenez]

Hello Community!

I need a filter to show all Epics that are true to these two conditions:

1. Epic has a "Requirements" task (summary = "Requirements")

2. The "Requirements" task is the only issue type in the Epic, no other issue type has been created.

Thanks in advance, I hope this is a good explanation. 

HJ

[Bill Sheboy · Accepted solution]

Hi @Hiram Jimenez  -- Welcome to the Atlassian Community!

You cannot do that with out of the box Jira JQL.  You would need a marketplace addon or to export the project data to search in another tool, such as a spreadsheet.

Before you look for a tool, please confirm which version of Jira you are using (Cloud, or Server/Data Center) to help focus your search.

Best regards,

Bill

[Hiram Jimenez]

Hi Bill,

Thank you for your response, I am using Cloud.