Open topic with navigation

# 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.

© 2018 Micro Focus or one of its affiliates | Send documentation feedback to Micro Focus 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