Modifying Jira Filter to Include Only Features with specific Completed Tasks in Issue Links

[Mauricio Nava]

I'm seeking assistance in modifying an existing Jira filter to capture a more specific set of issues. The current filter is as follows:

project in (XYZ, QWERTY) AND issuetype = Feature AND labels in (ABC) ORDER BY summary ASC, priority ASC, updated DESC

This filter captures features with the label "ABC" in projects XYZ and QWERTY, sorted by summary, priority, and updated date.

However, I would like to further refine this filter to only include features that have an associated Issue Links task with the word "ERB" in its summary or label, and where that task is marked as done. Specifically, I'm interested in capturing features that have a task linked to them with the "has to be done after" link type, where the linked task contains "ERB" in its summary or has the label "ERB", and where the linked task is marked as done.

I'm new to Jira, so any help in modifying the filter to capture this specific set of issues would be greatly appreciated!

[Lisa Forstberg]

Hi @Mauricio Nava ,

Welcome to the community and welcome to Jira!

It seems you are on Jira data center. When exploring and learning JQL to filter for tickets in Jira  the JQL / advanced searching documentation is a very good place to go for guidance.

You have a base filter that you want to narrow further based on the links to specific type of issues with a specific attribute.

the function offered in advanced searching is Issue in LinkedIssues() . This a good start, but the limitation is that you cannot within the brackets add an advanced subquery. Basically it only searches for linked to one specific issue, not many

Examples in the documentation:

• Find issues that are linked to a particular issue:
  issue in linkedIssues(ABC-123)
• Find issues that are linked to a particular issue via a particular type of link:
  issue in linkedIssues(ABC-123,"is duplicated by")

The addon Scriptrunner offers more advanced search with linked issues

issueFunction in linkedIssuesOf(YOUR SUBQUERY)

First check if you have Scriptrunner installed. See if you can get a match on "issueFunction in" in your JQL query line.If not...I am afraid the search options are too limited to perform what you are after.

all the best

Lisa