Category Component 26.1
Category Component Help

# EQUALALL

The `EQUALALL` field specifier (case sensitive) allows you to find documents in which a specified field occurs in multiple instances, and in which there is at least one value among those instances that is equal to each of a set of numeric values that you specify.

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

## Format

    FieldText=EQUALALL{yourValues}:yourNumericField

`yourValues` | One or more numeric values. A document returns only if all these values occur among the instances of `yourNumericField`. Separate the numbers with commas (there must be no space before or after a comma).
`yourNumericField` | The name of the field to match against. A document returns only if it contains the field and only if all `yourValues` match at least once in various instances of the field.

## Example

    FieldText=EQUALALL{32,98.6,212}:FAHRENHEIT

The `FAHRENHEIT` fields must include at least the values 32, 98.6, and 212 for the document to return as a result.

    FieldText=EQUALALL{1999,2000,2001}:YEAR

The values 1999, 2000, and 2001 must all appear in the `YEAR` fields for the document to return as a result.

Copyright 2025 Open Text
Version 26.1 | Last updated January 2026

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: Knowledge Discovery Category Component 26.1

Topic Title: EQUALALL