Hi, I'm new here. How do I filter subitems with blocked status under requirements?

[Amit]

I'd like to filter all the requirements which are open (new, in progress etc.) where the subitems are in blocked status. Any help is greatly appreciated

Subitems (user stories, backlog, tasks) have relation resolves, resolved by etc. to the requirements

I've written the following query. Now how do I apply a filter of status blocked on the subitems I get from this query.

project = xxx AND issuetype = Requirement AND status not in (Blocked, "On Hold") AND (issueLinkType in (resolved-by, resolves, "created by", "depends on") )

Looking forward to a solution.

Best,

Amit

[Raunak Maskay]

You're on the right track! In Jira JQL, unfortunately, you can't directly filter based on the linked issue's status in standard JQL. Jira’s native JQL doesn’t support traversing issue links to filter by properties of linked issues like sub-tasks, stories, or other linked requirements. However, you can achieve this in a couple of ways depending on what plugins or tools you have.

Option 1: Using JQL + ScriptRunner (or similar add-ons)

If you have ScriptRunner installed, you can use enhanced JQL functions to query linked issue statuses.

Here’s a query example:
issueFunction in linkedIssuesOf(
"project = xxx AND status = Blocked",
"resolved by"
) AND issuetype = Requirement AND status not in (Blocked, "On Hold")

This query breaks down as:

• Finds all issues linked to issues that are in 'Blocked' status.

• Filters only the Requirement issues that are not Blocked or On Hold.

You can swap "resolved by" with other link types (resolves, depends on, etc.) as needed.

If you want to include multiple link types, you might do:
issueFunction in linkedIssuesOf(
"project = xxx AND status = Blocked",
"resolves, resolved by, depends on, created by"
) AND issuetype = Requirement AND status not in (Blocked, "On Hold")

Option 2: Without ScriptRunner (limitations)

If you don’t have ScriptRunner, you’ll need a manual or semi-automated workaround, like:

1. Exporting issues and their linked issue keys.

2. Using Excel or Google Sheets to map linked issue statuses.

3. Flagging parent Requirements where at least one linked issue is Blocked.

Or alternatively:

• Tag linked subitems (stories, tasks) with a label like blocked-subitem.

• Then search using:

issueFunction in linkedIssuesOf("labels = blocked-subitem", "resolved by")

Pro Tips

• Ask your Jira admin if ScriptRunner or Automation for Jira is available. It unlocks much richer queries and automation.

• You can also build Dashboards using filters + gadgets to visualize these requirements + blocked subitems.