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

[Arkadiusz Głowacki · Accepted solution]

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

[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]

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")

[Paul]

Hi Rikki, this query is what I am looking for. Is there a way to use this query to add multiple statuses though?

[sudhakar · Accepted solution]

Hi

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