nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to compare the status of linked issues ?

Thierry Bourhis

Hello,

In JIRA, is it possible to build a filter that would find linked issues that will have differents states?

The issues could be in differents projects

The issues can have several links

This will help us to better follow our topics.

Exemple :

Issue_Number / State / Linked issue(s)

Project1-11 / OPEN / Project2-22 Project3-33

Project2-22 / CLOSED / Project1-11

Project3-33 / OPEN / Project1-11

The result of query will be : Project2-22 / CLOSED/ Project1-11 / OPEN

Greetings,

Thierry BOURHIS

Accepted answers

sudhakar_0i9ort

We can get the list linked issues that are in different status using the plugin" JQL Search Extensions" .

JQL : issue in linkedIssueStatus("To Do") is gives us list of linked issues which are in To Do status like that we can get the list of issues in different status .

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-LinkedIssueStatus

Regards,

Sudhakar

Arkadiusz Głowacki

Hi @T,

adding to what @sudhakar already wrote, you can use JQL Search Extensions to filter linked issues that are in particular status. So far it is not possible to satisfy ALL states with a single query and you will have to do it one by one, but if you are most interested in Closed issues where links are still open, then you can use status categories instead of statuses like:

cloud: statusCategory = Done and linkedIssueStatusCategory in ("To Do", "In Progress")

server: statusCategory = Done and issue in linkedIssueStatusCategory("To Do", "In Progress")

Focusing on status categories will satisfy all done or not done statuses, regardless of how you named them. If you prefer to use statuses then you will have to check them one by one like:

status = Closed and linkedIssueStatus in ("To Do", "In Progress", "Custom status 1")

status = Done and linkedIssueStatus in ("To Do", "In Progress", "Custom status 1")

status = "Custom status done" and linkedIssueStatus in ("To Do", "In Progress", "Custom status 1")

Regards

Arkadiusz Głowacki

All comments

sudhakar_0i9ort

We can get the list linked issues that are in different status using the plugin" JQL Search Extensions" .

JQL : issue in linkedIssueStatus("To Do") is gives us list of linked issues which are in To Do status like that we can get the list of issues in different status .

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-LinkedIssueStatus

Regards,

Sudhakar

Arkadiusz Głowacki

Hi @T,

cloud: statusCategory = Done and linkedIssueStatusCategory in ("To Do", "In Progress")

server: statusCategory = Done and issue in linkedIssueStatusCategory("To Do", "In Progress")

Focusing on status categories will satisfy all done or not done statuses, regardless of how you named them. If you prefer to use statuses then you will have to check them one by one like:

status = Closed and linkedIssueStatus in ("To Do", "In Progress", "Custom status 1")

status = Done and linkedIssueStatus in ("To Do", "In Progress", "Custom status 1")

status = "Custom status done" and linkedIssueStatus in ("To Do", "In Progress", "Custom status 1")

Regards

Arkadiusz Głowacki

Thierry Bourhis

Hello,

Thanks a lot for your response.

And do you know if it is possible to find such link with : Scriptrunner (we have this plugin)?

https://scriptrunner.adaptavist.com/latest/jira/quickstart.html

Thanks for your help,

Regards

Thierry Bourhis

Arkadiusz Głowacki

Hello,

I have no experience with scriptRunner so, unfortunately, I can't help with this plugin.

Regards

Arkadiusz Głowacki

Rikki Worsfold_cixn03

I know this answer was solved a while ago, but if you are still looking for a ScriptRunner solution you could use this filter:

status != "IN PROGRESS" AND issueFunction in linkedIssuesOf("status = \"IN PROGRESS\"")

Or for items that are not closed but are linked to closed items:

resolution is EMPTY AND issueFunction in linkedIssuesOf("resolution is not EMPTY")