Open topic with navigation

# At Least One Field Instance Matches a Specified String or Number

You can use the following field specifiers (case sensitive) to return documents with multiple instances of the same fields and at least one field instance contains a specified string or number.

## MATCHALL

The `MATCHALL` 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 match among those instances for each of a set of strings that you specify.

NOTE:

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

    FieldText=MATCHALL{yourStrings}:yourField

where:

`yourStrings` | is one or more strings. A document returns only if all these strings have exact matches among the instances of `yourField`. Separate the strings with commas (there must be no space before or after a comma). FieldText queries which include commas and braces within the query have specific percent-encoding requirements. For information about percent-encoding, see FieldText.
`yourField` | is the name of the field to match against. A document returns only if it contains the field and only if all `yourStrings` are matched at least once in various instances of the field.

Examples:

    FieldText=MATCHALL{Archive,Web,docs}:DIRECTORY

The `DIRECTORY` fields must include at least the values Archive and Web and docs for the document to return as a result.

    FieldText=MATCHALL{Smith,Garcia,Lee}:SURNAME

The values Smith, Garcia, and Lee must all have matches in the `SURNAME` fields for the document to return as a result.

    FieldText=MATCHALL{Smith%5C, John, Garcia%5C, Joaquin}:FULLNAME

The values Smith, John and Garcia, Joaquin must both have matches in the `FULLNAME` fields for the document to return as a result.

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

    FieldText=EQUALALL{yourValues}:yourNumericField

where:

`yourValues` | is 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` | is the name of the field to match against. A document returns only if it contains the field and only if all `yourValues` are matched 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 `YEAR` fields for the document to return as a result.

© 2018 EntIT Software LLC, a Micro Focus company | 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