IDOL Category Component 24.2

# Fields that Contain a Number

You can use the following field specifiers (case sensitive) to return documents with fields that contain numbers. To optimize the processing time of queries for fields that contain numbers, store them as numeric fields in the IDOL Content component during the indexing process.

Related Topics

- NumericType Fields

## EQUAL

The `EQUAL` field specifier (case sensitive) allows you to find documents in which a specified field contains a number that matches one of the numbers specified by you.

    FieldText=EQUAL{yourNumbers}:yourFields

where:

`yourNumbers` | is one or more numbers. A document returns only if one of `yourFields` contains one of these numbers.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if this field contains one of `yourNumbers`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=EQUAL{1234567890123}:ACCOUNT:KONTO

The `ACCOUNT` or `KONTO` field must contain the number 1234567890123 for the document to return.

    FieldText=EQUAL{3.9,4.9,7}:ID

The `ID` field must contain the number 3.9, 3.90, 4.9, 4.90, 7, or 7.0 for the document to return.

## GREATER

The `GREATER` field specifier (case sensitive) allows you to find documents in which a specified field contains a number that is greater than a number you specify.

    FieldText=GREATER{yourNumber}:yourFields

where:

`yourNumber` | is a number. A document returns only if one of `yourFields` contains a number that is greater than this number. By default, the range is exclusive. You can add an equals sign (=) to include the number that you specify.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the number in this field is greater than `yourNumber`. To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=GREATER{66}:ID

The `ID` field must contain a number greater than 66 for the document to return.

    FieldText=GREATER{5.59}:PRICE:PREIS

The `PRICE` or `PREIS` field must contain a number greater than 5.59 for the document to return.

    FieldText=GREATER{=6}:QUANTITY

The `QUANTITY` field must contain a value of 6 or greater for the document to return.

## LESS

The `LESS` field specifier (case sensitive) allows you to find documents in which a specified field contains a number that is smaller than a number that you specify.

    FieldText=LESS{yourNumber}:yourFields

where:

`yourNumber` | is a number. A document returns only if one of `yourFields` contains a number that is smaller than this number. By default, the range is exclusive. You can add an equals sign (=) to include the number that you specify.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the number in this field is smaller than `yourNumber`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=LESS{66}:ID

The `ID` field must contain a smaller number than 66 for the document to return.

    FieldText=LESS{5.59}:PRICE:PREIS

The `PRICE` or `PREIS` field must contain a smaller number than 5.59 for the document to return.

    FieldText=LESS{=6}:QUANTITY

The `QUANTITY` field must contain a value of 6 or lower for the document to return.

## NOTEQUAL

The `NOTEQUAL` field specifier (case sensitive) allows you to find documents in which a specified field contains a number that does not match a number that you specify.

    FieldText=NOTEQUAL{yourNumber}:yourFields

where:

`yourNumber` | is a number. A document returns only if one of `yourFields` does not contain this number.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if this field does not contain `yourNumber`. To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=NOTEQUAL{1234567890123}:ACCOUNT:KONTO

The `ACCOUNT` or `KONTO` field must not contain the number 1234567890123 for the document to return.

    FieldText=NOTEQUAL{3.9}:ID

The `ID` field must not contain the number 3.9 for this document to return.

## NRANGE

The `NRANGE` field specifier (case sensitive) allows you to find documents in which a specified field contains a number that falls in the inclusive range of two numbers that you specify.

    FieldText=NRANGE{yourNumbers}:yourFields

where:

`yourNumbers` | is two numbers, separated by a comma (there must be no space before or after the comma). A document returns only if one of `yourFields` contains a number that falls within the inclusive range of the specified numbers (including decimal numbers). By default, the range is inclusive. You can use the greater than (<) and less than (>) symbols to specify an exclusive range. You can make either or both ends of the range exclusive.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if this field contains a number that falls within the inclusive range of `yourNumbers`. To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=NRANGE{1,99}:CODE

The `CODE` field must contain a number between 1 and 99 (inclusive) for the document to return.

    FieldText=NRANGE{1234567890123,2345678901234}:ACCOUNT:KONTO

The `ACCOUNT` or `KONTO` field must contain a number between 1234567890123 and 2345678901234 (inclusive) for the document to return.

    FieldText=NRANGE{36.5,42.3}:CODE

The `CODE` field must contain a number between 36.5 and 42.3 (inclusive) for the document to return.

    FieldText=NRANGE{>1,5}:CODE

The `CODE` field must contain a value that is greater than 1, up to and including 5 for the document to return.

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

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 MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL IDOL Category Component 24.2

Topic Title: Fields that Contain a Number