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

[Thomas Zosh]

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?

[Jobin Kuruvilla [Adaptavist]]

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