Hi, I want to write a filter for issues based on the "related issues" filed.

[Victor Crespo]

I want to filter the issues that in "related issues" have issues that fulfill a specific condition.

I don't know how to address this problem. Can anybody give a clue about how to face it?

[Walter Buggenhout · Accepted solution]

Hi @Victor Crespo,

As you haven't listed the hosting type of your Jira instance, there may be some additional things you'll have to verify for my reply to work for your case.

However, out of the box, Jira does not support this type of requests very well. Searching for conditions on related or linked issues usually requires functionality of marketplace apps.

The most commonly used app would be Scriptrunner, which offers additional JQL functions. The following query would then be able to accommodate what you are after:

Project = ABC AND issuefunction in LinkedIssuesOf("Project = DEF AND Priority = Medium")

In my example, I used an additional query to represent the issues that fulfill a specific condition. You can obviously modify that to reflect your own use case. 

Hope this helps!

[Victor Crespo]

Thank you Walter. It is just what I need.

[Daniel Turczanski - JQL Search Extensions]

Hi @Victor Crespo ,

With standard JQL, you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service: JQL Search Extensions

After you install the app, you can simply search:

issue in linkedIssuesOfQuery("project=ACME and statusCategory='To Do'")

Check out the documentation to see more examples.

I hope this helps!

Daniel

[Victor Crespo]

Good point. Thank you Daniel.