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