Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to compare the status of linked issues ?

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

2 answers

2 accepted

2 votes
Answer accepted

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

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

Hello,

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

 

Regards

Arkadiusz Głowacki

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

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

2 votes
Answer accepted

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you