mongoDb find by matching multiple values from same index object array

Question

I have this documents inside my db, example:

{x: 10, y: 20, val: "h"}
{x: 20, y: 70, val: "ho"}
{x: 30, y: 80, val: "hol"}
{x: 40, y: 90, val: "hola"}
{x: 50, y: 29, val: "holas"}

i want to get all the documents matching x and y values by passing an array, exampe:

[{x: 10, y 20},{x: 20, y 70}]

so to return me:

[{x: 10, y: 20, val: "h"},{x: 20, y: 70, val: "ho"}]

i have tryed in this way but doesn't work:

var ricerca = {
   $in: [{x: 10, y 20},{x: 20, y 70}]
};

db.collection('exampe').find(ricerca).toArray(...

Saravana · Accepted Answer · 2019-01-19 00:40:36Z

1

you need to use $or

$or: [{x: 10, y: 20},{x: 20, y: 70}]

answered Jan 19, 2019 at 0:40

Saravana

12.8k2 gold badges42 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1