Find documents by an array of objects

Question

I want to create a query in MongoDB to to find documents by and array of objects which exactly math document property.

I have documents:

{meta: {prop1: "hi1", prop2: "ho1"}},
{meta: {prop1: "hi2", prop2: "ho2"}},
{meta: {prop1: "hi3", prop2: "ho3"}},
{meta: {prop1: "hi1", prop2: "ho2"}}

I want to find documents whose meta property is one of exact objects in this array:

[
  {prop1: "hi1", prop2: "ho1"}, {prop1: "hi2", prop2: "ho2"}
]

Desired result would be documents:

{meta: {prop1: "hi1", prop2: "ho1"}},
{meta: {prop1: "hi2", prop2: "ho2"}}

but not:

{meta: {prop1: "hi1", prop2: "ho1"}},
{meta: {prop1: "hi2", prop2: "ho2"}},
{meta: {prop1: "hi1", prop2: "ho2"}}

Mikey · Accepted Answer · 2017-07-25 23:32:08Z

1

Use $in operator.

Collection.find({
    meta:  { 
        $in: [
            { prop1: 'hi1', prop2: 'ho1'}, 
            { prop1: 'hi2', prop2: 'ho2'}
        ]
    } 
})

answered Jul 25, 2017 at 23:32

Mikey

6,7564 gold badges25 silver badges49 bronze badges

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

Comments

hardy · Accepted Answer · 2017-07-25 23:38:46Z

0

We can Use $or for this -

Collection.find({
        $or: [
            {'meta.prop1': 'hi1', 'meta.prop2': 'ho1'},
            { 'meta.prop1': 'hi2', 'meta.prop2': 'ho2'}
        ]
})

Note: inside object of $or, $and condition is build.

We can use $in also because $in is inbuilt using $or.

answered Jul 25, 2017 at 23:38

hardy

9013 gold badges14 silver badges31 bronze badges

Collectives™ on Stack Overflow

Find documents by an array of objects

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related