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
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.
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")
If you don’t have ScriptRunner, you’ll need a manual or semi-automated workaround, like:
Exporting issues and their linked issue keys.
Using Excel or Google Sheets to map linked issue statuses.
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")
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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.