Number Range Operator

The Number range operator enables you to search for numbers or number ranges. What is considered a number is tokenizer specific.

Syntax

Semantics

<

less than

<=

less than or equal to

=

equal to

<>

not equal to

>

greater than

>=

greater than or equal to



Parentheses

Parentheses removes ambiguity when searching for a term or field value. For field value searches, the field name should be followed by a number range operator. If the field is a Boolean field, an error is given as number range operators are not allowed on Boolean fields.

Month > 10 searches all documents that have a value in field month > 10
Month (>10) searches all documents that contain the word 'month' followed by a number > 1


Examples

Example of query

Results

"60615"

60615, and also 1-60615-769 and (60615)43
But not 60,615 and $60615 and 60615a

Note: placed between double quotes it is not a numeric query anymore and you can use fuzzy on it. For more information, see Fuzzy Searches.

60615

60615, and also 1-60615-769 and (60615)43 and 60,615 and $60615 and €60,615

(>=65) w/10 social security

Number 65 or higher within 10 terms from social security.

(> 21) AND high school graduate

22, high school graduate

23, high school graduate

etc.

(>1 : <10)

All values between 1 and 10.

  • 1.000000000001
  • 2
  • 3.333333
  • 9.9999999999999

Note: searches of this type take time to execute. A lack of system resources may cause the search to error out.

(<> 5)

Will find documents with numbers, but not with the value 5 in it. At least one other number than 5 should be present.

It is not similar to 'NOT 5'. This query will find all documents that do not contain the number 5.


Note: The maximum upper boundary for the numeric repetition range has been set to the maximum length of decoded words, 128, defined by the Tokenizer.

The rules for the numbers within numeric repetition:

  1. \{m\} where m is a positive whole number such that 0 < m <= 128
  2. \{m,n\} where m and n are positive whole numbers such that 0 <= m <= 128, 0 < n <= 128, n > m