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. We are going to execute the following code after getting a connection to the database, the same as we did in the former section:
rethinkdb.table('users').filter(function (user) {
return...