I have a ticket custom field which is a date e.g. “Site Work Completed”, and would like to search for all
tickets which have another CF, “Site Work Required” = 1 where the date in “Site Work Completed” is blank.
Can’t seem to get the RT search builder to do what I want though as it only seems to support for dates
“before”, “on” or “after” but not “IS NOT…” or “IS BLANK”
AND 'CF.{Site Work Required}' = 1 AND NOT 'CF.{Site Work Completed}' > '1970-01-01'
Status = '__Active__' AND 'CF.{Site Work Required}' = 1 AND 'CF.{Site Work Completed}' < '1970-01-01' AND Queue = 'Support'
Status = '__Active__' AND 'CF.{Site Work Required}' = 1 AND Queue = 'Support' AND ( 'CF.{Site Work Completed}' = '' )
I can get it to do the opposite of what I want (those having a date filled in) but not a search for date not filled in.
Any ideas?
Thanks