Query value in sub-document dictionary MongoDB

Question

I have the following document:

"_id" : 19,
"name" : "Elizabeth Moore",
"achronym" : "EM19",
"calc" : {
    "20" : {
        "role" : 20,
        "score" : 15,
        "inRole" : false,
        "range" : {
            "int" : 80,
            "min" : 20
        }

and I need to retrieve all _ids having "calc.inRole" false.

I tried:

db.coll.find({'calc.$.inRole': false})
db.coll.find({'calc.inRole': false})

but none of these worked.

How can I achieve that?

mickl · Accepted Answer · 2019-05-16 11:05:51Z

0

Since calc has fields with unknown keys you need to run $objectToArray to transofrm it into array of keys and values. Then you can run $in on that array. If you want to have it as single pipeline step you can use $let operator to define temporary variable:

db.collection.aggregate([
    {
        $match: {
            $expr:{ 
                $let: {
                    vars: {
                        arr: { $objectToArray: "$calc" }
                    },
                    in: {
                        $in: [ false, "$$arr.v.inRole" ]
                    }
                }
            }
        }
    },
    {
        $project: {
            _id: 1
        }
    }
])

Mongo Playground

answered May 16, 2019 at 11:05

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

Query value in sub-document dictionary 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