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?

[somethingblue · Accepted solution]

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]" =

[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

[Yousuf.Khamisani]

Thank you @Chad Nuesmeyer 

[Rahul Raina]

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.

[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]

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