Fields that Contain a Number

You can use the following field specifiers (case sensitive) to return documents with fields that contain numbers. To optimize the processing time of queries for fields that contain numbers, store them as numeric fields in the IDOL Content component during the indexing process.

EQUAL

The EQUAL field specifier (case sensitive) allows you to find documents in which a specified field contains a number that matches one of the numbers specified by you.

FieldText=EQUAL{yourNumbers}:yourFields

where:

yourNumbers is one or more numbers. A document returns only if one of yourFields contains one of these numbers.
yourFields

is one or more fields. A document returns only if it contains one of these fields, and if this field contains one of yourNumbers.

If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

FieldText=EQUAL{1234567890123}:ACCOUNT:KONTO

The ACCOUNT or KONTO field must contain the number 1234567890123 for the document to return.

FieldText=EQUAL{3.9,4.9,7}:ID

The ID field must contain the number 3.9, 3.90, 4.9, 4.90, 7, or 7.0 for the document to return.

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 number you specify.

FieldText=GREATER{yourNumber}:yourFields

where:

yourNumber

is 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

is 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.

To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

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.

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 number that you specify.

FieldText=LESS{yourNumber}:yourFields

where:

yourNumber

is 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

is 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.

If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

FieldText=LESS{66}:ID

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

FieldText=LESS{5.59}:PRICE:PREIS

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

FieldText=LESS{=6}:QUANTITY

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

NOTEQUAL

The NOTEQUAL field specifier (case sensitive) allows you to find documents in which a specified field contains a number that does not match a number that you specify.

FieldText=NOTEQUAL{yourNumber}:yourFields

where:

yourNumber is a number. A document returns only if one of yourFields does not contain this number.
yourFields

is one or more fields. A document returns only if it contains one of these fields, and if this field does not contain yourNumber.

To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

FieldText=NOTEQUAL{1234567890123}:ACCOUNT:KONTO

The ACCOUNT or KONTO field must not contain the number 1234567890123 for the document to return.

FieldText=NOTEQUAL{3.9}:ID

The ID field must not contain the number 3.9 for this document to return.

NRANGE

The NRANGE field specifier (case sensitive) allows you to find documents in which a specified field contains a number that falls in the inclusive range of two numbers that you specify.

FieldText=NRANGE{yourNumbers}:yourFields

where:

yourNumbers

is 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

is 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.

To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

FieldText=NRANGE{1,99}:CODE

The CODE field must contain a number between 1 and 99 (inclusive) for the document to return.

FieldText=NRANGE{1234567890123,2345678901234}:ACCOUNT:KONTO

The ACCOUNT or KONTO field must contain a number between 1234567890123 and 2345678901234 (inclusive) for the 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 the 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 for the document to return.


_HP_HTML5_bannerTitle.htm