Open topic with navigation

# EMPTY

The `EMPTY` field specifier (case sensitive) allows you to find documents in which a specified field doesn't exist or contains no value.

NOTE:

You can optimize the field specifier speed by restricting the field to the NumericType property type.

## Format

    FieldText=EMPTY{}:yourFields

`yourFields` | One or more fields. A document returns only if it does not contain any of these fields or if these fields are empty. Separate multiple fields with colons (`:`). There must be no space before or after a colon.

## Example

    FieldText=EMPTY{}:ID

A document returns if it does not contain an `ID` field or if the `ID` field is empty.

    FieldText=EMPTY{}:ID:Name

A document returns if it does not contain an `ID` or `Name` field, or if the `ID` and `Name` field are empty.

© Copyright 2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm