The following FieldText operators are available in IDOL server. For more information about usage, refer to the IDOL Server Reference.
| Operator | Finds |
|---|---|
MATCH
|
a value that exactly matches one or more specified strings. |
EQUAL
|
a number that exactly matches the specified number. |
GREATER
|
a number that is greater than the specified number. |
LESS
|
a number that is smaller than the specified number. |
NRANGE
|
a number that falls in the specified range. |
NOTEQUAL
|
a number that does not match the specified number. |
GTNOW
|
a date after the current date. |
LTNOW
|
a date before the current date. |
RANGE
|
a date that falls in the specified range. |
WILD
|
a value that matches the specified wildcard string. |
ARANGE
|
a value in a specified alphabetical range. |
BITAND
|
a value that gives a non-zero value for a specific bitwise AND operation against a specified value. |
BITANDHEX
|
a hexadecimal value that gives a non-zero value for a specific bitwise AND operation against a specified hexadecimal value. |
BITANDOFFHEX
|
a hexadecimal value that gives a non-zero value for a specific bitwise AND operation against a specified hexadecimal value, with an offset. |
BITSET
|
a value in a bit field where the specified bit is set. |
BOOLEANFIELD
|
a Boolean or Proximity agent expression that matches the specified text. |
DISTCARTESIAN
|
Cartesian coordinate values within a specified distance from a specified point. |
DISTSPHERICAL
|
latitude and longitude values within a specified distance from a specified point. |
EMPTY
|
documents in which the specified field is empty or does not exist. |
EXISTS
|
documents that contain the specified field, irrespective of its value. |
FUZZY
|
a value similar to the specified string. |
LENGTH
|
a value with a specified length. |
MATCHALL
|
documents that contain all the specified strings in multiple instances of the specified field. |
EQUALALL
|
documents that contain all the specified numbers in multiple instances of the specified field. |
MATCHCOVER
|
documents that contain all the specified strings in multiple instances of the specified field, but where none of the instances of the field contain a value that is not specified. |
EQUALCOVER
|
documents that contain all the specified numbers in multiple instances of the specified field, but where none of the instances of the field contain a value that is not specified. |
MATCHRECURSE
|
documents that contain a specified reference, recursively to a specified number of matches. |
NOTMATCH
|
documents that contain at least one instance of the specified field that does not contain a value that exactly matches the specified value. |
NOTSTRING
|
documents that contain at least one instance of the specified field that does not contain a string that matches the specified string value. |
NOTWILD
|
documents that contain a least one instance of the specified field that does not contain a string that matches the specified wildcard value. |
POLYGON
|
a Cartesian coordinate value that falls within a specified polygonal shape. See POLYGON FieldText Search. |
STRING
|
a specified string value. |
STRINGALL
|
all the specified values in at least one instance of the field. |
SUBSTRING
|
a value that is a substring of the specified value. |
TERM
|
a value that matches the stem of the specified values. |
TERMALL
|
documents that contain values that match the stem of all the specified values in multiple instances of the specified field. |
TERMEXACT
|
a value that contain the specified term. |
TERMEXACTALL |
documents where the specified field contains an exact match of all the specified terms. |
TERMEXACTPHRASE
|
a value that contains the specified phrase. |
TERMPHRASE |
documents where the specified field contains a conceptual match of a specified phrase (that is, terms in the phrase are stemmed, but stop words are not removed). |
The following field operators allow you to bias results towards those that contain a particular value, by boosting relevance for certain values.
| Operator | Description |
|---|---|
BIAS
|
Bias the result relevance according to the numerical proximity of the specified field to a specified value. |
BIASDATE
|
Bias the result relevance according to the proximity of a date in the specified field to a specified date. |
BIASDISTCARTESIAN
|
Bias the result relevance according to the proximity of Cartesian coordinates to a specified position. |
BIASDISTSPHERICAL
|
Bias the result relevance according to the proximity of the latitude and longitude values to a specified position. |
BIASVAL
|
Bias the result relevance when the specified field contains a specified value. |
|
|