Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Complex JQL query with custom multi attribute field.

Marie McClain November 22, 2019

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. 

1 answer

1 accepted

0 votes
Answer accepted
Jack Brickey
Community Champion
November 23, 2019

Suggest an answer

Log in or Sign up to answer