IDOL Category Component 24.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 2024 Open Text
Version 24.2 | Last updated March 2024

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 MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL IDOL Category Component 24.2

Topic Title: EMPTY