Query to show Issue with dependencies on other teams

Adam Taylor_xih0w1

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

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