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

How do I form a JQL search around the "Team" field for issues that have no teams assigned?

Abel Lineberger

Currently searching on Team supports positive searches aka:

Show me all issues assigned to team X
jql: project=project and team="team X"
Show me all issues assigned to multiple teams ( X, Y, Z)
jql: project=project and team in "team X, team Y, team Z"

What I cannot search is "show me all issues not assigned to a team" as there is no support for either != or "not in" or even "is empty" or "= empty".

Ideas?

Comments

somethingblue

Hi Abel,

There is a current feature request around the limitation of the JQL surrounding the Team field that you can find at JPOSERVER-1695. Please vote on this issue and add your use case to the comments so our developers can see the impact and consider adding this functionality in an upcoming JIRA release.

Cheers,

Branden

Abel Lineberger

Done!

Thanks Branden!

somethingblue

No problem Abel. I'm happy I was able to point you in the right direction. Have a great rest of your week!

Branden

Chad Nuesmeyer

It is crazy how long it took me to figure this out:

"Team[Team]" =

Screenshot 2020-11-13 114729.png

border_water

@Chad Nuesmeyer

Is the above working for you ?

If my team name is TeamXYZ, do I have to mention "Team[Team]" = "TeamXYZ" in the Query ?

Thanks

nish_saxena

Using "Teams[Select List (multiple choices)]" = TeamXYZ has solved the issue for me.

Jehan Bhathena

Hi,

Please can you provide more insight into this? Would like to try this out at my end as well.

Would like to know the custom field you made to map out the Team's values?

Jonathan Tang_ho04bf

The Team field is available when used with Jira Advanced Roadmaps.

Managing the teams would be under a tab Jira > Plans > View Shared Teams.
When used in JQL, the "Team" text will auto-resolve you to "Team[Team]" when selected at the prompt.
Like most JQL entries, once you set the =, you'll get a list of teams.
When that team is selected, it'll reconcile the the appropriate integer ID managed in JIRA.

A few changes are coming to teams very soon, so might read up on:
https://community.atlassian.com/t5/Advanced-Roadmaps-articles/Teams-in-Advanced-Roadmaps-What-s-changing-and-what-you-need-to/ba-p/2259096

Yousuf.Khamisani

Thank you @Chad Nuesmeyer

Rahul Raina_yuzyg8

Thank you for including this! The original poster's ability to search by name wasn't working for me. I also had to use your exact format in order to drive a query. Feels like a very fragile integration. Hope all the new teams work is resolving some of these hard edges.

Welcome!

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

Quick Links

Find more posts tagged with

jql

team

teamwork