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.


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.



The FAHRENHEIT fields must include at least the values 32, 98.6, and 212 for the document to return as a result.


The values 1999, 2000, and 2001 must all appear in the YEAR fields for the document to return as a result.