JQL query that returns any value from several projects except one exact project

[Kate Suchkova]

Is it possible to set several Jira projects except one in JQL query?

[Mikael Sandberg · Accepted solution]

Hi @Kate Suchkova,

Welcome to the Atlassian Community.

If you would like to exclude a project from your JQL you could use project != my-project, this will get you issues from all projects except my-project. If you want to specify a subset of projects you can use project in (proj1, proj2, proj3), this will only give you issues in those three projects. 

[Craig Castle-Mead]

To expand on this answer by @Mikael Sandberg you can combine a wide get and then remove a project - eg: 

category in ("CategoryA") and project NOT IN ("SecretProject","HideMe")

this would get all projects in CategoryA except for SecretProject and HideMe

As you can see on https://community.atlassian.com/t5/Jira-questions/quot-project-not-in-quot-filter-fails-with-quot-value-does-not/qaq-p/36040 though, if you’re sharing the filter, make sure all users have access to the projects mentioned in the JQL or it may fail. 

CCM

[Kate Suchkova]

Thanks for your help! @Mikael Sandberg @Craig Castle-Mead