JQL to show Epics from current PI having dependencies

Florin-Mihai Mot March 19, 2024

How to build a filter/ insert JQL criteria to show the Epics from the current PI having dependencies ("is blocked by"/ "blocks") then to show also the Stories inside those Epics.

Many thanks in advance!

1 answer

1 vote
Mikel Garcia Bartolome March 19, 2024

Foremost, hello and thanks for asking.

What you are asking for is to make a sub query, using JQL as far as I know you can't make sub queries without using third plugins, the query to get the epic is the following:

project = <your_project_key>
   AND issuetype = Epic
   AND (sprint in openSprints())
   AND ("is blocked by" OR "blocks" is not EMPTY)
   ORDER BY Rank ASC

Explanation

  • project = <your_project_key>: Replace <your_project_key> with your actual project key.
  • issuetype = Epic: This clause selects only Epic issues.
  • (sprint in openSprints()): This part identifies Epics that are directly assigned to the current PI (sprint).
  • "is blocked by" OR "blocks" is not EMPTY: This clause checks for any dependency links ("is blocked by" or "blocks") associated with the Epics

Using the Filter

  1. Go to Search for Issues (JQL) in your Jira project.
  2. Paste the JQL criteria into the search bar.
  3. Click Search.

This will display a list of Epics from the current PI that have dependencies with other issues. The list will be sorted by the Epic Rank.

Suggest an answer

Log in or Sign up to answer