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.


_HP_HTML5_bannerTitle.htm