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

[Sara.B]

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

[Sara.B · Accepted solution]

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

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]

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

[Kalyan Sattaluri]

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

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]

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

[Kalyan Sattaluri]

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

[Sara.B]

@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? 

[Matt Parks]

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

[Kalyan Sattaluri]

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)