Query to show Issue with dependencies on other teams

Adam Taylor March 1, 2023

Hi all,

In our Jira project with have multiple teams, each with their own team number using a bespoke 'team' field. I would like to be able to easily filter for Issues that show dependencies between teams - i.e. to show Issues that have a relationship to Issues in other Teams.

I have created a filter that shows where an Issue has a dependency on another Issue

project = sq and issuelinktype in ("is blocked by", blocks, Blocks,"has to be finished together with", "has to be done after", "has to be done before", "has to be started together with")

I'd like to take this further by showing only those Issues where the related Issue is assigned to a different Team than itself.

Possible?

2 answers

1 accepted

1 vote
Answer accepted
Kristján Geir Mathiesen
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 1, 2023

Hi @Adam Taylor 

Good question. I don't think you can do that with OOTB Jira since there is no JQL function to look at the team on the current issue and thereby exclude that team.

If you don't have too many teams, you could include a filter in your query and that way do a filter per team. For example, create a filter that shows all issues for a certain team. Save that filter as "Team A Filter". Then include that filter in your filter above with the "not in" operater. Example:

filter != "Team A Filter" AND (project = sq and issuelinktype in ("is blocked by", blocks, Blocks,"has to be finished together with", "has to be done after", "has to be done before", "has to be started together with"))


Try that out.

HTH,
KGM

Kristján Geir Mathiesen
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 1, 2023

To explain better, use the "Team A Filter" to intersect with your filter and that way rule out Team A. However, you'll have to do a filter (more correct, 2 filters) per team.

0 votes
Vachu Kabbinale
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 9, 2024

Hi Kristjan, I tried your suggestion today by creating 2 filters to list cross-project dependencies. It doesn't work.  Is there any other machanism we could implement this.

I have 3 projects A, B, C. I use issuelinktype ("is blocked by").

I want to list only dependencies between A, B and A,C,  NOT A,A

Thank you

/vachu

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events