Complex JQL query with custom multi attribute field. Edited

[Marie_McClain]

How do I find the opposite of this jql- all issues not meeting these exact criteria?

Custom Field = "Value 1" AND Custom Field = "Value 2" AND Custom Field = "Value 3" AND Custom Field = "Value 4" AND Custom Field = "Value 5" AND Custom Field = "Value 6" AND Custom Field = "Value 7"

This is a custom field with checkbox attributes. I am pulling out all tickets that meet all 7 criteria/attributes(easy enough to do)  and then I need to isolate all tickets that have the custom field null/empty or don't have all 7 attributes checked (not so easy). 

I would like to act on both scenarios to move the ticket to a different status in Service Desk. 

[Jack · Accepted solution]

Duplicate post