JQL Query to find Epics that have only one open Task

[Kadamannaya, Vishwas]

Hello All,

I am trying to write a JQL query in jira to get an overview of all the Epics that has 1 Tasks which is open or not completed.

Basic idea is to target those epics those has 1 open task , to complete this open task and close the epic.

• Epic1
  • Task 1 - Done
  • Task 2 - Done
  • Task 3 - Open

The Query should return Epic 1 , because it has one open Task "Task 3" , to be completed.

Regards

Vishwa