Searching for Null Values

It is possible to perform a search to determine whether or not a value has been set for a field. When a field has no value, it is considered to be <Null>; on the other hand, when a field has a value, it is <Not Null>.

The following steps describe how these macros can be used in queries:

 

1    Open the Query Editor for the desired project.

2    Create the query using <Null> and <Not Null> as desired (use Like for the Test column).

                 Example:

                  Priority Like <Null> AND Severity Like <Not Null>

NOTE: Searching for null values in Date, Time, and Number fields will require a few additional steps. Please contact support for more information.

 

3 Export the query to the Web view(s) and regenerate the view(s).

 

NOTE: Saved queries with <Null> and <Not Null> can only be used from the Web views, not from the Preview in the Admin editors.

 

It is also possible to use the <Null> and <Not Null> using the Ad-hoc Query editor of any given Web view. Simply select a Field, choose Like for the Test option, and type either <Null> or <Not Null> in the Value textbox.

Related Topics

Searching for Strings

Searching for Wildcards