How can I find issues that have linked issues of type X in a status Done ?

Question

Hello! I am using JIRA Cloud.
Let's say I have two issuetypes: X and Y.

And let's say there are different possible relationships between issuetypes X and Y.

For example: related to, is blocked by, and so on.

I wanna

1. Find all issues of type X that have related to issues of type Y, where every related issue is in status Done

2. Find all issues of type X that have related to issues of type Y, where at least one related issue is in status Done?

How can I achieve that? Looking for exact solution if possible.

Thanks in advance!

Craig Nodwell_7eve9b · Answer

Sorry I cannot.  :(  Maybe someone else has ideas beyond mine.

However with a plugin for better filter results you could make this happen, again this is only on me there may be others in the community that may have knowledge beyond mine.
Re:
Scriptrunner would give you expanded jql functions like linkedIssuesOf()
If you are setting your resolution on Done tickets this would find all tickets in x that are linked to tickets that are linked that are closed
issue = X and issueIssueLinkType = "depends on" AND issueFunction in linkedIssuesOf("resolution is not EMPTY")

JQL Search Extensions would give you this
issue = X and issueIssueLinkType = "depends on" and linkedIssueStatusCategory not in ("To Do", "In Progress")

Andrey Ponomarenko_19did2 · Answer

Hello! Thank you for your answer!

1. This JQL returns not just issues of type X, but also Done issues of type Y
I wanna get issues only of type X.

Also this JQL returns issues of type X in status DONE. But I do not care in what status is issue of type X. I wanna get all issues of type X regardless of type X status. The only criteria for issue of type X is that all related issues of type Y are done

2. This JQL again return issues of both types X and Y. But I need only type X

Any Ideas how to improve your JQL?

Craig Nodwell_7eve9b · Answer

issueLinkType Documentation

issueType

This link has links to fields functions keywords and operators and should give you a lot of help.

Advanced Search Reference Jira Cloud

This would be my approach, I hope this helps:  (it may need some tweaking to get what you are looking for but this should get you started).

1. issueType in (X,Y) and issueLinkType = "related to" and status = Done

2. issueType in (X,Y) and issueLinkType = "related to" and statusCategory in ("To Do", "In Progress", Done)