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

Create a JQL Query for linked issues which ignores issues in specific Projects

David Young_p6ebn1

I am trying to create a JQL query to generate a list of tickets which are linked issues. For example,

1. project = ABC

2. Issues in project which have linked issues

3. Restrict "linkedissues" to issues not in "project = ABC"

4. List show the "linkedissues"

I'm playing around with the following query:

project = ABC AND issueFunction in linkedIssuesOf("resolution = unresolved", "relates to")

This generates a list of "project = ABC" tickets with unresolved links, but includes issues within ABC. How do I generate a list that will exclude "linkedissues" in "project = ABC"?

The next question will be, how to I generate the list of the those restricted "linkedissues", not the list of issues in "project = ABC"?

Accepted answers

David Young_p6ebn1

So the final answer to this query filter is:

project != "ABC" AND status not in (Closed, Canceled, Done, Resolved) AND issueFunction in linkedIssuesOf("resolution = unresolved AND project = ABC", "relates to")

This will show all tickets which "project =ABC" are linked to that are not in a closed state and are still open for "project = ABC". What this allows me, and anyone else to do, is keep track of work assigned to other teams that may, or may not, impact the progress of "project = ABC" and allow for easy follow-up as needed.

I am using this on a two projects tracking potential impediments to my team's success.

All comments

Scott Theus

Hi @David Young ,

Welcome to the Community! I'm working to improve my JQL skills, to this may or may not work, but have you tried this?

project = ABC AND (issueFunction in linkedIssuesOf("resolution = unresolved", "relates to") and project not in ABC)

-Scott

Scott Theus

BTW...I don't have a server instance, so I couldn't test it.

David Young_p6ebn1

@Scott Theus

The query you put looks straight forward, but it doesn't meet my needs. At the end of the query, the "project not in (ABC) cancels out the opening part of the query. I need to filter the issuelinks list. That is the part that I find challenging. The query you posted filters the same project, and cancels itself out.

I had tried a similar approach earlier with no success.

Scott Theus

I was afraid of that, thanks for trying it.

Antoine Berry

Hi,

Maybe I have missed something but why would you not add the exclusion in the sub-query ?

project = ABC AND issueFunction in linkedIssuesOf("resolution = unresolved AND project != ABC", "relates to")

David Young_p6ebn1

@Antoine Berry

What I trying to accomplish is create a list of tickets, not in my project, which are impacting the progress of my project. For example, my software development team will need to create tickets for our system admins, platform technologies, and DevOps teams for action. Then we link those tickets to the software development tickets my team is working on. I'm putting a dashboard together that tracks our progress and ensures that the team doesn't fall behind or neglect a ticket to another team. That is my goal. Does that make sense?

Antoine Berry

Yes, that makes sense. I am not sure which project is your "main" though, I guess you want to track issues in your secondary project ? Anyway the above should work with some tweaks if necessary.

David Young_p6ebn1

Thanks @Antoine Berry that gets me halfway there. The result of this is that it I get a list of my software development project ticket with "issuelinks>'relates to'" outside of my software development project. Now the trick is to generate a list of those "relates to" tickets based on their connection to my software development project.

So my thought is to invert the query to something like this:

project ="Platform" AND issueFunction in linkedIssuesOf("resolution = unresolved AND project = ABC", "relates to")

This now generates the list of tickets in the Platform projects with links to my software development project. Thanks greatly, that helps me out huge. I can even expand it to:

project != ABC AND issueFunction in linkedIssuesOf("resolution = unresolved AND project = ABC", "relates to")

Which will then show a list of all tickets created in my system which are open but have links to my software development project. This is a broad list and has a lot of noise in it. But I can even select specific project get the results I want:

project in (DevOps, Platform, "Corp IT) AND issueFunction in linkedIssuesOf("resolution = unresolved AND project = ABC", "relates to")

This limits it to those tickets which directly impact my team.

@Antoine Berrythank you. You got me all the way there in the end. I appreciate it.

David Young_p6ebn1

So the final answer to this query filter is:

project != "ABC" AND status not in (Closed, Canceled, Done, Resolved) AND issueFunction in linkedIssuesOf("resolution = unresolved AND project = ABC", "relates to")

I am using this on a two projects tracking potential impediments to my team's success.