Open topic with navigation

# GREATER

The `GREATER` field specifier (case sensitive) allows you to find documents in which a specified field contains a number that is greater than a specified number.

NOTE:

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

## Format

    FieldText=GREATER{yourNumber}:yourFields

`yourNumber` | A number. A document returns only if one of `yourFields` contains a number that is greater 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 greater than `yourNumber`. Separate multiple fields with colons (`:`). There must be no space before or after a colon.

## Example

    FieldText=GREATER{66}:ID

The `ID` field must contain a number greater than 66 for the document to return.

    FieldText=GREATER{5.59}:PRICE:PREIS

The `PRICE` or `PREIS` field must contain a number greater than 5.59 for the document to return.

    FieldText=GREATER{=6}:QUANTITY

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

© 2018 Micro Focus or one of its affiliates | Send documentation feedback to Micro Focus 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