finding array element in an object

Question

"features" : {
    "en" : [ 
        {
            "translatable" : true,
            "capacity " : [ 
                "128GB", 
                "256GB"
            ]
        }, 
        {
            "translatable" : true,
            "material  " : [ 
                "Glass", 
                "Aluminium"
            ]
        }
    ]
}

I am finding 'capacity': '128GB' when I am using this query

db.getCollection('products').find({
    'features.en' : {
        $elemMatch : {
            'capacity' : {
                $in : ['128GB']
            }
        }
    }
})

But not fetching. If i query for 'translatable':true

db.getCollection('products').find({
    'features.en' : {
        $elemMatch : {
            'translatable' : true
        }
    }
})

profesor79 · Accepted Answer · 2016-05-11 12:27:31Z

2

there is a tricky TYPO in your input document - so please check if capacity has a SPACE at the end

db.prod.aggregate([{
            $match : {
                "features.en.capacity " : "128GB"
            }
        },
    ]).pretty()

to get only array element that mets your criteria you can use this aggregation query:

db.prod.aggregate([{
            $unwind : "$features.en"
        }, {
            $match : {
                "features.en.translatable" : true
            }
        }, {
            $match : {
                "features.en.capacity " : "128GB"
            }
        },
    ]).pretty()

edited May 11, 2016 at 12:27

answered May 11, 2016 at 12:24

profesor79

9,5033 gold badges36 silver badges53 bronze badges

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

1 Comment

Mohammad Kashif Sulaiman Over a year ago

Thanks, you are right, it wasn't working because of the TYPO

sumair · Accepted Answer · 2016-05-11 12:21:46Z

0

Have you tried this

db.products.find({'features.en': { $elemMatch: {'capacity': {$elemMatch:{$in: ['128GB']}}} } })

answered May 11, 2016 at 12:21

sumair

3863 silver badges8 bronze badges

Collectives™ on Stack Overflow

finding array element in an object

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related