table.between(lower_key, upper_key[, options]) → table_slice table_slice.between(lower_key, upper_key[, options]) → table_slice
Get all documents between two keys. Accepts three optional arguments:
index is set to the name of a secondary index,
between will return all documents where that index’s value is in the specified range (it uses the primary key by default).
right_bound may be set to
closed to indicate whether or not to include that endpoint of the range (by default,
left_bound is closed and
right_bound is open).
You may also use the special constants
r.maxval for boundaries, which represent “less than any index key” and “more than any index key” respectively. For instance, if you use
r.minval as the lower key, then
between will return all documents whose primary keys (or indexes) are less than the specified upper key.
If you use arrays as indexes (compound indexes), they will be sorted using lexicographical order. Take the following range as an example:
[[1, "c"] ... [5, "e"]]
This range includes all compound keys:
Example: Find all users with primary key >= 10 and < 20 (a normal half-open interval).
Example: Find all users with primary key >= 10 and <= 20 (an interval closed on both sides).
r.table('marvel').between(10, 20, :right_bound => 'closed').run(conn)
Example: Find all users with primary key < 20.
Example: Find all users with primary key > 10.
r.table('marvel').between(10, r.maxval, :left_bound => 'open').run(conn)
Example: Between can be used on secondary indexes too. Just pass an optional index argument giving the secondary index to query.
r.table('dc').between('dark_knight', 'man_of_steel', :index => 'code_name').run(conn)
Example: Get all users whose full name is between “John Smith” and “Wade Welles.”
r.table("users").between(["Smith", "John"], ["Welles", "Wade"], :index => "full_name").run(conn)
Example: Get the top 10 ranked teams in order.
r.table("teams").order_by(:index => "rank").between(1, 11).run(conn)
between is chained after order_by, both commands must use the same index;
between will default to the index
order_by is using, so in this example
"rank" is automatically being used by
between. Trying to specify another index will result in a
Example: Subscribe to a changefeed of teams ranked in the top 10.
changes = r.table("teams").between(1, 11, :index => "rank").changes().run(conn)
betweencommand works with secondary indexes on date fields, but will not work with unindexed date fields. To test whether a date value is between two other dates, use the during command, not
Secondary indexes can be used in extremely powerful ways with
betweenand other commands; read the full article on secondary indexes for examples using boolean operations,
RethinkDB uses byte-wise ordering for
betweenand does not support Unicode collations; non-ASCII characters will be sorted by UTF-8 codepoint.
Couldn't find what you were looking for?
© RethinkDB contributors
Licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License.