IDOL Category Component 24.2

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

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: At Least One Field Instance Matches a Specified String or Number