JQL to Find Issues for "Not Available" Teams

[Steve Goodwin]

Hi,

A team was deleted from Jira, while still being populated in the Team field for some issues. I noticed that in filter results the Team field is now showing "Not Available." The Team field apparently still retains the deleted team's ID.

Is there a way in JQL to filter for issues where the Team field is populated with a no-longer-valid team ID?

(Note: the Team field isn't empty, so "Team[Team]" is Empty isn't an option)

[Vronik · Accepted solution]

Hi

It's certainly not the best solution, but if you know the ID of the deleted team, you can add

"where team <> ID No." to the query.

Regards

[Steve Goodwin]

Thanks, @VronikThat would certainly work for a one-off situation where the ID was known.

I was really looking for a generic solution for all invalid IDs, sort of like the inactiveUser() function that can be used for people fields.

I've created a Jira feature suggestion for a JQL function to return invalid Team IDs. 

Thanks again, @Vronik