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

Search status of Linked Issue in different Project

Chris Hardy_a7tb47

Hi,

The title pretty much describes what I'd like to do. We have a project of Issues that are often linked to issues in another project. We'd like to do a JQL query to find issues based on the status of the issues in the other project.

I've search multiple places but have yet to find something on the status, even when you use (Project = "").

Has anyone else done this before?

Thanks

Chris

Accepted answers

All comments

Zita Bagi

Hello there, you can try something like

issueLinkType in (blocks) AND status in ("Open", "In Progress")

So this is not restricted to projects, it searched for only a link type (replace it with the type of link(s) you are using) and then you can select which statuses you want to search for.

Or if you use

Project in (X, Y, Z) AND issueLinkType in (blocks, causes) AND status not in (Closed, Resloved, Done, Canceled)

it will show all the open issue with a link type it certain projects. Or you can exclude a project by Project not in (....).

Is this what you were looking for?

Chris Hardy_a7tb47

Thanks, but this is not quite what we want. We want to be able to filter on the status of the linked issue. For example, what open issues in project A are linked to a closed issue in Project B.

Does that make sense?

Zita Bagi

Based on

https://community.atlassian.com/t5/Jira-questions/Get-list-of-linked-issues-how-to/qaq-p/95753

I managed to create

project=A AND status=Open AND issue in linkedIssues(B-36, "relates to")

which shows the Open issues of project A which are linked to B-36 with the "relates to" link type.

If I understand correctly, instead of linkedIssues(B-36, "relates to") you would prefer something like linkedIssues(Closed, "relates to"), but linkedIssues work only like this: linkedIssues(issueKey, linkType).

Zita Bagi

Now based on

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#undefined

I made

issueFunction in linkedIssuesOf("project = B", "relates to") and status=Open and Project=A

This lists the Open issues in project A which have a "relates to" link type to any issues of project B. It still lacks the specification of Closed issues of project B.

These linked issue queries only work if you have ScriptRunner add-on.

I also tried issueFunction in linkedIssuesOf("project = B", "status=Closed") and status=Open and Project="A" which doesn't give me a result but it is marked correct with a green tick.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-desk

jira-service-desk-cloud