IDOL Category Component 12.12

# ARANGE

The `ARANGE` field specifier (case sensitive) allows you to find documents in which a specified field contains a term that falls within the inclusive alphabetical range of two terms specified by you.

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

## Format

    FieldText=ARANGE{yourTerms}:yourFields

`yourTerms` | Type two terms separated by a comma (there must be no space before or after the comma). A document returns only if one of `yourFields` contains a term that falls within the inclusive alphabetical range of the specified terms. You can use a full stop (`.`) in place of one of the terms, to represent an unrestricted value. Use the full stop in place of the first term to include all values up to the second term. Use the full stop in place of the second term to include all values after the first term. NOTE: IDOL Category Component uses unicode tables to determine alphabetical order. This means that non-7-bit ASCII characters (ä, å, ç, d, ê, ë, ø, ö, ü, û, ß, ÿ, and so on) come after z in the alphabet.
`yourFields` | Type one or more fields. A document returns only if it contains one of these fields, and if this field contains a term that falls within the inclusive alphabetical range of `yourTerms`. Separate multiple fields with colons (`:`). There must be no space before or after a colon.

## Example

    FieldText=ARANGE{aardvark,alligator}:ANIMAL

The `ANIMAL` field must contain a value that alphabetically falls between `aardvark` and `alligator`. A document returns if the `ANIMAL` field contains the value `aardvark`, `ant`, `anteater`, `antelope` or `alligator`. If the `ANIMAL` field contains the value `armadillo`, it does not return.

    FieldText=ARANGE{bear,buffalo}:ANIMAL:TIER

The `ANIMAL` or `TIER` field must contain a value that alphabetically falls between `bear` and `buffalo`. A document returns if the `ANIMAL` or `TIER` field contains the value `bear`, `bee`, `Biene`, `bird` or `buffalo`. If the `ANIMAL` field contains the value `Büffel` or `chipmunk`, it does not return.

    FieldText=ARANGE{dog,.}:ANIMAL AND ARANGE{.,cat}:PET

The `ANIMAL` field must contain a value that alphabetically falls after `dog`, and the `PET` field must contain a value that alphabetically falls before `cat`.

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.12 | Last updated June 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.12

Topic Title: ARANGE