Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Query for open Stories and Tasks within open Epics

I want to be able to query for open Stories and Tasks within open Epics. What JQL can I use for this query? When I pull in "Status", it seems to be the status of the Story or Task, not not for the Epic. I need to be able to distinguish between the two status'.

3 answers

1 vote
Guilhem Dupuy Community Leader Dec 30, 2020


You can try the following JQL :

issuetype IN (Story, Task) AND "Epic Status" != Done


Let me know if it helped,


Hi @bangaru ganesh  -- Welcome to the Atlassian Community!

I do not believe you can do that with out of the box Jira, as JQL is not a full SQL language.  You would need a scripting add-on from the marketplace.

As a work-around, you could export the project issues to a spreadsheet, or use the Excel or Google Sheets addons for Jira, and perform the join manually between the open issues and their open epics.

Best regards,


Hi @bangaru ganesh 

As an alternative you may want to try out our add-on to manage multiple Epics and their hierarchy on a single page.

Agile Tools - Epic Tree and Time in Status 

Manage and visualize your Epics with rolled up estimate progress reports.

Key features:

  • Epic Sum
  • Configure progress % calculation on either "remaining estimate" or "original estimates"
  • Epic Tree directly on Issue Screen
  • Display and manage Epics/Issues of your project
  • Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
  • Rolled up percentage completion and at issue level as well
  • JQL support for Epic Hierarchy screen
  • Time in Status report using JQL
  • Issue Tracker to view complete transitions on your issue screen
    • Status Transition : View all the status changes in a single tab along with average time and count in each status. Switch between graphical and tabular view to make more out of the data.
    • Assignee Transition : View all the assignees for the issue along with the time for which the issue was with each assignee. Switch between graphical and tabular view to make more out of the data.


Epic Hierarchy Screen_Cloud_Edit.png


Epic Hierarchy_Issue Screen_Cloud.PNG

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,105 views 8 28
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you