When you configure the index feature, you can set fields to the numeric type and query key values by number range.
long (long integers) and
double (decimals). If you set a field to a numeric type, only values within a number range
can be used to query the key value.
To query the key value of longkey whose range is (1000 2000], use the following methods:
Query by specifying the numbers. Example:
longKey > 1000 and longKey <= 2000
Query by specifying the number range. Example:
longKey in (1000 2000]
For more information about syntax, see Query syntax.