Numeric search
Numeric search is very similar to text search. The only difference is that the search string must begin with one of the relational operators ">" (greater than), ">=" (greater than or equal to), "<" (less than), or "<=" (less than or equal to).
Only values that fulfill the numeric requirement will be matched.
You can combine multiple numeric operators in a single search.
Numeric searches can also be used to filter date fields.
The following table contains additional examples of numeric searches, with explanations of the results.
Example | Result |
---|---|
>900 | Finds all values greater than 900. |
<=900 | Finds all values less than or equal to 900. |
>900<1000 | Finds all values greater than 900 and less than 1000. |
<900>1000 | Finds all values less than 900 or greater than 1000. |