Open topic with navigation

# FieldText Operators

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.
`GEOCONTAINS` | a polygonal region that contains a specified point or polygonal shape.
`GEOINTERSECTS` | a Cartesian coordinate value or polygonal region that falls wholly or partially within a specified polygonal shape.
`GEOWITHIN` | a Cartesian coordinate value or polygonal region that falls wholly within a specified polygonal shape.
`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 or polygonal region that falls wholly 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.

© 2018 Micro Focus or one of its affiliates | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm