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.
Numeric search for field values with one comparison (greater than 20)
You can combine multiple numeric operators in a single search.
Numeric search for field values with multiple comparisons (greater than or equal to five, and less than 20)
Numeric searches can also be used to filter date fields.
Numeric search for dates on and after January 8, 2018
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. |