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

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

Advanced search using JQL for epics without stories

I would like to identify easily epics which have no user stories - I can't work out how to do this using JQL search, any advice?

1 answer

1 accepted

0 votes
Answer accepted
Tarun Sapra Community Leader Apr 04, 2019

Hello @Andrea_Parker 

It's not possible to do this without an plugin.

If you have the paid plugin Script runner installed then you can easily do it.

issuetype = Epic and issueFunction not in hasLinkType("Epic-Story Link")

the above JQL will give you all epics in the system which don't have a child story.

Thank you Tarun; we don't have that plug-in so I shall do it manually.

Suggest an answer

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

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

3,888 views 11 5
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