Query with unknown keys in mongodb

Question

I have a collection with documents like:

{   
   map:{
     key1:value1,
     key2:value2, 
     ....
    }
}

and I want to filter documents based on map values only, regardless the keys, something like map.* equal some value. Is it possible to do that?

MongoDB version used is 3.4

You can use $arrayToObject and objectToArray aggregation. Something like this db.collection.aggregate([ { $project: { map: { $objectToArray: "$map" } } }, { $match: { "map.v": "value1" } }, { $project: { map: { $arrayToObject: "$map" } } } ]) — Ashh
– Ashh, Commented Sep 24, 2018 at 8:57

Ashh · Accepted Answer · 2018-09-24 18:28:07Z

6

You can try below aggregation using $objectToArray and $arrayToObject aggregation operators

db.collection.aggregate([
  { "$project": { "map": { "$objectToArray": "$map" }}},
  { "$match": { "map.v": "value1" }},
  { "$project": { "map": { "$arrayToObject": "$map" }}}
])

answered Sep 24, 2018 at 18:28

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Query with unknown keys in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related