How to Search for a Null Value: Difference between revisions

From The New York Botanical Garden
Jump to navigation Jump to search
No edit summary
No edit summary
Line 19: Line 19:
:[[File:ClipCapIt-151123-162641.PNG|File:ClipCapIt-151123-162641.PNG]]
:[[File:ClipCapIt-151123-162641.PNG|File:ClipCapIt-151123-162641.PNG]]


:[[File:ClipCapIt-151123-162658.PNG|File:ClipCapIt-151123-162658.PNG]]
:[[File:ClipCapIt-221024-130101.PNG|File:ClipCapIt-221024-130101.PNG]]
 
:[[File:ClipCapIt-221024-130002.PNG|File:ClipCapIt-221024-13002.PNG]]

Revision as of 17:01, 24 October 2022

Or how to search for records with nothing saved in a field.

It is not uncommon to want to search for records with a null value in a particular field (i.e., a field that is blank). Which wildcard character string you use will depend on what it is that you don’t want to find.

Remember, EMu supports Unicode, which means you must use a backslash (\) character before every wildcard character used in a search.

In EMu, the exclamation mark specifies NOT. Thus:

\!\+ in an attachment field will return all records where there is no attachment in that field.

\!\* in any field will return records where there is no value in a field.

Keep in mind that these searches take longer than searches using complete words.

Example

Find all Lecythis specimens without images:

File:ClipCapIt-151123-162641.PNG
File:ClipCapIt-221024-130101.PNG