IDOL Category Component 24.2

# NRANGE

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

NOTE: You can optimize the field specifier speed by restricting the field to the `NumericType` property type.

## Format

    FieldText=NRANGE{yourNumbers}:yourFields

`yourNumbers` | 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. You can specify an open-ended range by setting one of these values to be a period (`.`).
`yourFields` | 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`. Separate multiple fields with colons (`:`). There must be no space before or after a colon.

## Example

    FieldText=NRANGE{1,99}:CODE

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

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

The `ACCOUNT` or `KONTO` field must contain a number between `1234567890123` and `2345678901234` (inclusive) for this 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 this 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.

    FieldText=NRANGE{50,.}:PRICE

The `PRICE` field must contain a value greater than or equal to 50 for this 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: NRANGE