IDOL Category Component 12.11

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

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.11 | Last updated February 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 IDOL Category Component 12.11

Topic Title: NRANGE