IDOL 12.13

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

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.13 | Last updated October 2022

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL 12.13

Topic Title: FieldText Operators