How to apply filter on array in ReQL in ReThinkDB using JavaScript

Question

In the following JSON, I want to pick the records that have sales > 12500. How do I do that in ReThinkDB and ReQL?

JSON is:

{
 "address": {  
    "address_line1":  "Address Line 1" ,
    "address_line2":  "Address Line 2" ,
    "city":  "Kochin" ,
    "country":  "India" ,
    "state":  "Kerala"
  } ,
  "id":  "bbe6a9c4-ad9d-4a69-9743-d5aff115b280" ,
  "name":  "Dealer 1" ,
  "products": [
         {
           "product_name":  "Stabilizer" ,
           "sales": 12000
         } ,
         {
           "product_name":  "Induction Cooker" ,
           "sales": 14000
         }
    ]
   }, {
    "address": {
          "address_line1":  "Address Line 1" ,
          "address_line2":  "Address Line 2" ,
          "city":  "Kochin" ,
          "country":  "India" ,
          "state":  "Kerala"
     } ,
     "id":  "f033a4c2-959c-4e2f-a07d-d1a688100ed7" ,
     "name":  "Dealer 2" ,
     "products": [
           {
            "product_name":  "Stabilizer" ,
            "sales": 13000
           } ,
           {
            "product_name":  "Induction Cooker" ,
            "sales": 11000
           }
      ]

}

What do you want as the output of this? A list of products like `{product_name: "Stabilizer", sales: 13000}`? Or the full document for all documents that have at least one product with a sufficiently high sales number? — Daniel Mewes, Apr 01 '15 at 22:08
I want full document for all documents with sales over 12,500 for ANY product. Is that possible? — KAdditude, Apr 09 '15 at 09:05
Ok that makes sense. I added my answer below. Hope that works. — Daniel Mewes, Apr 10 '15 at 21:21

score 13 · Accepted Answer · answered Apr 10 '15 at 21:20

To get all documents that have at least one sales value over 12,500 for any product, you can use the following filter in ReQL:

r.table('t')
 .filter(r.row('products').contains(function(product) {
   return product('sales').gt(12500);
 }))

This makes use of the fact that you can pass a function into contains. array.contains(fun) returns true exactly if fun returns true for at least one of the elements in array. You can find more examples at http://rethinkdb.com/api/javascript/contains/

How to apply filter on array in ReQL in ReThinkDB using JavaScript

1 Answers1