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