Query to show Issue with dependencies on other teams

[Adam Taylor]

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?

[Kristján Geir Mathiesen · Accepted solution]

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]

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.

[Vachu Kabbinale]

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