Category Component 25.2
Category Component Help

# 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` | 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 period (`.`) in place of one of the terms, to represent an unrestricted value. Use the period in place of the first term to include all values up to the second term. Use the period in place of the second term to include all values after the first term. NOTE: The Content 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` | 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 2025 Open Text
Version 25.2 | Last updated April 2025

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: Knowledge Discovery Category Component 25.2

Topic Title: ARANGE