Help w/ JQL that returns all stories linked to open Epics

Thomas Zosh February 9, 2018

I need help writing a JQL query that returns all Story, Bug and Improvement issue types (regardless of their status) that are linked to open Epics (Status != Ship It).  This query should also returns all open (Status != Ship It) Story, Bug or Improvement issues that are NOT tied to an Epic (via Epic Link).

Can someone help?

 

1 answer

0 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 12, 2018

For the first part, you need a plugin like JQL Tricks,  using which you can search for issues linked to Epics that matches a certain criteria.

The second part can be done without plugins. You can do something like:

issuetype in (Story, Bug, Improvement) AND Status != "Ship It" AND "Epic Link" is EMPTY

Suggest an answer

Log in or Sign up to answer