write a filter that excludes a key value

[fbicknel]

When I look at a list of issues, the column `Key` appears to indicate the project + a sequential number:

Key

FOO-23

BAR-42

I want to write a filter that will show me my issues, excluding a particular project (key value):

assignee = currentUser() AND resolution = Unresolved and key != "FOO-*" order by updated DESC

That's my guess, but I get:

The issue key 'FOO-*' for field 'key' is invalid.

Suggestions?

[Nic Brough -Adaptavist- · Accepted solution]

The key of an issue is <project>-<sequence>, but you can't use wildcards to search it.

However, as your query is about project, yes you can do this, just not with the issue key field.  Try:

assignee = currentUser() and resolution is empty and project not in (FOO, x, y, z) order by updated desc

I've been a little flexible with "project not in".  != would work fine for dropping a single project, but "not in ()" lets you name several projects to exclude.