Need to search for an empty field

I have created a custom field that I need to search. It comes up fine on
the search page but I need to search for empty values in the field. (No
Value)

I am running:
RT 3.2.2
Apache 2.0.51
RedHat Fedora C2

I have created a custom field that I need to search. It comes up fine on
the search page but I need to search for empty values in the field. (No
Value)

I am running:
RT 3.2.2
Apache 2.0.51
RedHat Fedora C2

Try: NULL

Nope…it just returns 0 records-----Original Message-----
From: Todd Chapman [mailto:todd@chaka.net]
Sent: Wednesday, July 20, 2005 2:29 PM
To: Leon
Cc: RT Users group
Subject: Re: [rt-users] need to search for an empty field

On Wed, Jul 20, 2005 at 02:46:07PM -0600, Leon wrote:

I have created a custom field that I need to search. It comes up fine on
the search page but I need to search for empty values in the field. (No
Value)

I am running:
RT 3.2.2
Apache 2.0.51
RedHat Fedora C2

Try: NULL

GOT IT!!! was using “contains” rather than “is” in my search criteria.-----Original Message-----
From: Todd Chapman [mailto:todd@chaka.net]
Sent: Wednesday, July 20, 2005 2:29 PM
To: Leon
Cc: RT Users group
Subject: Re: [rt-users] need to search for an empty field

On Wed, Jul 20, 2005 at 02:46:07PM -0600, Leon wrote:

I have created a custom field that I need to search. It comes up fine on
the search page but I need to search for empty values in the field. (No
Value)

I am running:
RT 3.2.2
Apache 2.0.51
RedHat Fedora C2

Try: NULL