MongoDb Access array of objects with certain property

Question

I have one document as follows:

{
    user: 'hvt07',
    photos: [
    {
        link: 'http://link.to.com/image1.jpg',
        isPrivate: true
    },
    {
        link: 'http://link.to.com/image2.jpg',
        isPrivate: false
    }
    ]
}

I want to get all photos which are with:

isPrivate: false

I am using the following query:

db.collection_name.find({ photos:{ $elemMatch:{isPrivate: false} } }).pretty()

I have also tried:

db.collection_name.find({'photos.isPrivate': true}).pretty()

But both return all elements in the array even ones that are set as :

isPrivate: true

Please suggest.

Sede · Accepted Answer · 2015-05-14 07:34:59Z

7

Aggregation is the solution.

You need to deconstruct the photos array using the $unwind operator. Next use the $match to select documents where isPrivate: false. The $group you can regroup your documents by _id and reconstruct your photos array using the $push operator

db.collection_name.aggregate(
     [
       {$unwind: "$photos"}, 
       {$match: {"photos.isPrivate": false}}, 
       {$group: {"_id": {"id": "$_id", "user": "$user"}, photos: {$push: "$photos"}}}
       {$project: {"_id": "$_id.id", "user": "$_id.user", "photos": 1, "_id": 0 }}
     ]
)

edited May 14, 2015 at 7:34

answered May 13, 2015 at 12:22

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

Comments

Toan Nguyen · Accepted Answer · 2015-05-13 12:35:53Z

0

You can use $elemMatch to the result projection like this

db.collection_name.find(
{ photos:{ $elemMatch:{isPrivate: false} } },   //1

{photos:{$elemMatch:{isPrivate: false}}})  //2

Find all documents that have at least a photo which is not private
Select only photos that are not private for the documents found.

answered May 13, 2015 at 12:35

Toan Nguyen

11.6k5 gold badges46 silver badges61 bronze badges

1 Comment

HVT7 Over a year ago

This returns only the first record and not all records with "{isPrivate: false}"

Collectives™ on Stack Overflow

MongoDb Access array of objects with certain property

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related