IDOL Server 23.2

# 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 2023 Open Text
Version 23.2 | Last updated March 2023

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Server 23.2

Topic Title: EMPTY