Search on number and money fields
You can use search operators to search on number and money fields.
Search operators
Type of search | Operator | Format | Example |
---|---|---|---|
Ranges | … | Three dots between numbers. |
3...20 This example will find numbers between 3 and 20. |
Greater than | > | Right angle bracket before a number. |
>1000 This example will find numbers from 1001 to the highest number in the index. |
Lesser than | < | Left angle bracket before a number. |
<1000 This example will find numbers from 1 to 999. |
Anything except this number | # | Hash symbol before a number. |
#3 This example will find any number except 3. |