Filtering nested arrays with RethinkDB

gistfile1.js

r.table("test").filter( function(doc) {
    return doc("adresses").contains(function(adress) {
        return adress("city").eq("Paris")
    })
})



/*
{
    name: "Bob",
        adresses: [
       	    {
                country: "France",
                city: "Paris"
            }
        ]
    }

*/

Looks like as required in RethinkDB 2.3.6. It returns the whole objects which contains addresses that contain at least one city=Havana. Of course it returns other addresses too, because only filter for searching was used (no data plucking).

Btw thanks for the query, i was searching for exactly this.

Another possibility is https://stackoverflow.com/questions/60583155/how-can-i-filter-if-any-value-of-an-array-is-contained-in-another-array-in-rethi

👍