I want to set up a filter which shows me the open tickets with closed link tickets

Sara_B February 22, 2024

I am using below filter to access the list of tickets which have a link to a resolution ticket and this resolution ticket is closed. sometimes there are more than one resolution ticket linked to the main ticket and not all closed. I want to have only the tickets which all the resolution tickets are closed. 

 

below is the filter that I am using but it brings also the ones which have for e.g 1 closed resolution ticket but one or more open resolution ticket (the link type for resolution is Resolved by) can it be adjusted in a way to show only the tickets where all the resolution tickets are closed. ?

(issueFunction in linkedIssuesOf(" project in (X) AND 'Issuetype' = Problem AND status!= closed ", "resolved by") AND type != Problem AND project = X AND resolution = Resolved)

 

Thanks

3 answers

1 accepted

0 votes
Answer accepted
Sara_B February 22, 2024

@Kalyan Sattaluri actually there would be no difference if I add status = Closed . resolution= resolved is only valid by changing the status to closed automatically, it is just the type of closure, can be either resolved or reject etc. 

my filter will look to tickets that have at least 1 closed resolved by but it does not consider if there are other ones but not closed yet. 

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2024

Thanks @Sara_B , we have a similar set up so just wanted to confirm. So I saw your original post.. Let me rephrase the scenario:

If I have 2 issues of Problem type like below:

Key = ABCD-100 (issuetype = Problem, status = Open) & has Link type = "resolved by" for:

-----> Key = ABCD-101 (issuetype != Problem, status = Closed)

-----> Key = ABCD-102 (issuetype != Problem, status = Closed)

 

 

Key = ABCD-123 (issuetype = Problem, status = Open) & has Link type = "resolved by" for:

-----> Key = ABCD-124 (issuetype != Problem, status = Open)

-----> Key = ABCD-125 (issuetype != Problem, status = Closed)

 

What do you do want to see?

Do you want to see ABCD-100 because its still open but links are closed.. OR

Do you want to see ABCD-101, ABCD-102, ABCD-125 because they linked and are closed.

Sara_B February 26, 2024

@Kalyan Sattaluri I want to see ABCD-100 because its still open but links are closed.

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

@Sara_B 

Below gives issues where at least one of the linked issues is closed.

project = XXXX and

issuetype = Problem and

status != Closed and

issueFunction in linkedIssuesOf("status =Closed and issuetype != Problem", "resolved by")

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

You can also specify multiple link types like below:

project = XXXX and

issuetype = Problem and

status != Closed and

issueFunction in linkedIssuesOf("status =Closed and issuetype != Problem", "resolved by", "resolves")

 

If you want issues where ALL linked issues are done

project = XXXX and

issuetype = Problem and

status != Closed and

issueFunction in linkedIssuesOf("status =Closed and issuetype != Problem", "resolved by", "resolves")

AND NOT 

issueFunction in linkedIssuesOf("status !=Closed and issuetype != Problem", "resolved by", "resolves")

Sara_B February 27, 2024

Thanks, the above is giving me the result I want. :) 

Like Kalyan Sattaluri likes this
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 27, 2024

Great, please consider accepting answer so that its useful for folks researching in future. Thanks!

Sara_B March 18, 2024

@Kalyan Sattaluri Hello, I want to build a filter to show me the problem tickets which have closed resolved bys but in the resolved by ticket itself there are still open Tested by ticket. so a link to link filter. I have tried something like this but it gives error : issueFunction in linkedIssuesOf("status=Closed and (issueFunction in linkedIssuesOf ("status !=Closed", "tests"))", "resolves") 

 

Do you know if it is possible to build a filter like this? 

0 votes
Matt Parks
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2024

You will need to add in an additional clause where the issuefunction NOT IN status != closed.

In your JQL, I can't exactly tell which is the resolution ticket and which isn't, but it would be something like this:

(issueFunction in linkedIssuesOf(" project in (X) AND 'Issuetype' = Problem AND status!= closed ", "resolved by") and (issueFunction not in linkedIssuesOf(" project in (X) AND 'Issuetype' = Problem AND status!= closed ", "resolved by")

0 votes
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2024

Hello @Sara_B 

At a glance, your JQL seems correct, it should give you linked issues where resolution = resolved... but when you say, you want "tickets where resolution is closed", wondering if in your set up, can an issue be resolved but status not closed?

Have you tried below?

(issueFunction in linkedIssuesOf(" project in (X) AND 'Issuetype' = Problem AND status!= closed ", "resolved by") AND type != Problem AND project = X AND resolution = Resolved AND status = Closed)

As said, to me your JQL seems fine, Also, I would suggest you try with a single issue where you think the discrepancy is.

(issueFunction in linkedIssuesOf(" key=ABCD-123 ", "resolved by") AND type != Problem AND project = X AND resolution = Resolved AND status = Closed)

Suggest an answer

Log in or Sign up to answer