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; } } }

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

Accepted answers

Sara.B

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

All comments

Kalyan Sattaluri_iinm1n

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)

Sara.B

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_iinm1n

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.

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

Sara.B

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

Kalyan Sattaluri_iinm1n

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

unknown-hosting-type