How to search for documents with empty fields

SYMPTOMS

You want to find documents with empty values in a specific field using ZyFIND.

CAUSE

Not applicable

RESOLUTION

Depending on the type of index, this is achieved in different ways.
The steps below apply to both HAPI and TBIE indexes.
Unless stated differently, the steps below are valid for both ZyFIND and the Web Client.

Non Module indexes (TXT/Tiff).

• {ZyFIND only} From the Fields tab, tick the field and leave it empty.
• Use wildcard expansion: NOT (in FIELD_NAME{*})

i.e. NOT (in scandate{*})

• Use the following search string in the Query box: ((FIELD_NAME "/FIELD_NAME"))

i.e. ((scandate "/scandate"))

XML Wrapper (XML/Tiff) and Database Fields Module indexes.​

• Use wildcard expansion: NOT (in FIELD_NAME{*})

           i.e. NOT (in scandate{*})

APPLIES TO

6.3; 6.4; 6.4 Service Pack 1