MongoDB: how to get specific elements from array?

Question

I have objects in the document that look's like:
my collections
I want to get only the elements from the 'transactions' array that their inside field 'isMatched' == false
I tried:

db.myCollection.find(
{ "transactions.isMatched": false } ,
    { "transactions.isMatched": 1 
    })

But i got all the array elements:
results

What is the appropriate query for this?

varman · Accepted Answer · 2020-08-17 10:34:46Z

1

You can achieve this with aggregation. $filter helps to eliminate unwanted objects.

db.collection.aggregate([
  {
    $project: {
      company: 1,
      transaction: {
        $filter: {
          input: "$transaction",
          cond: {
            $eq: [
              "$$this.isMatched",
              false
            ]
          }
        }
      }
    }
  }
])

Working Mongo playground

answered Aug 17, 2020 at 10:34

varman

8,9226 gold badges25 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: how to get specific elements from array?

What is the appropriate query for this?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

What is the appropriate query for this?

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related