Search for blank date in custom field

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

Okay… Some RTFM later, seems I have to make custom query to find blank CF:

Status = '__Active__' AND 'CF.{Site Work Required}' = 1 AND 'CF.{Site Work Completed}' IS NULL

1 Like