Mastering RethinkDB

Performing conditional queries

ReQL supports conditional queries using subqueries, expressions, and the lambda function. In this section, we will look at each one of them using sample code written in Node.js.

In order to perform these queries, I have populated our users table in the test database with some documents. Here is the query executed from the RethinkDB web administrative screen:

r.db('test').table('users').insert([{ 
name : "John", 
age : 24 
}, { 
name : "Mary", 
age : 32 
},{ 
name : "Michael", 
age : 28 
}]) 

Note

In the web administrative screen, you do not need to provide the run function with a connection; it automatically appends and executes the query on the server.

Let us run a query to find out documents with an age greater than 30 years. ...