Field Specifiers for Advanced Restrictions
Specifier | Use to find documents in which a specified field... |
---|---|
ARANGE
|
contains a value that falls within a specific alphabetical range |
BITAND , BITANDHEX , BITANDOFFHEX |
contains a value that results in a nonzero value when a bitwise AND operation is carried out against it |
BITSET
|
contains a value in a BitFieldType field where the specified bit is set |
BOOLEANFIELD
|
contains a Boolean agent |
DISTCARTESIAN
|
contains Cartesian (x/y) coordinates values within a specified distance from a specified point |
DISTSPHERICAL
|
contains latitude and longitude values within a specified distance from a specified point |
EMPTY
|
does not exist or does not contain a value |
EXISTS
|
exists, irrespective of its value |
FUZZY
|
contains a value that is similar to a specified string |
MATCHALL or EQUALALL |
contains multiple instances, whose values include at least one match for each of the specified strings or numeric values |
MATCHCOVER or EQUALCOVER |
contains multiple instances, all of whose values are matched in the specified strings or numeric values |
MATCHRECURSE
|
contains a specified reference in a ReferenceMemoryMappedType field recursively to a maximum number of times |
NOTMATCH , NOTSTRING , NOTWILD |
contains multiple instances, at least one of whose values does not match the specified string |
POLYGON
|
contains Cartesian (x/y) coordinate values within a specified polygonal shape |
GEOCONTAINS
|
contains a geospatial region that wholly contains a specified point or polygonal shape. |
GEOINTERSECTS
|
contains a point or geospatial region that intersects a specified point or polygonal shape |
GEOWITHIN
|
contains a point or geospatial region that is wholly within the specified polygonal shape. |
STRING , STRINGALL , SUBSTRING |
contains a specified string |
TERM , TERMALL , TERMEXACT , TERMEXACTALL , TERMEXACTPHRASE , TERMPHRASE |
whose value match specific terms or phrases |