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