Open topic with navigation

# 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 specified number.

NOTE:

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

## Format

    FieldText=LESS{yourNumber}:yourFields

`yourNumber` | 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` | 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`. Separate multiple fields with colons (there must be no space before or after a colon).

## Example

    FieldText=LESS{66}:ID

A document's ID field must contain a smaller number than 66 for this document to be returned.

    FieldText=LESS{5.59}:PRICE:PREIS

A document's `PRICE` or `PREIS` field must contain a smaller number than 5.59 for this document to be returned.

    FieldText=LESS{=6}:QUANTITY

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

© Copyright 2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm