MongoDB how to return multiple data in an array

Question

I have some data like

{"name":[{"age":15},{"age":18},{"age":20}]}

I want search age greater than 17, here is my script

db.test.find({"name.age":{"$gt":17}},{"name.age.$":1})

This will return

{"name":[{"age":18}]}

But I want get all data greater than 18

How to improve the script?

BatScream · Accepted Answer · 2015-05-19 19:32:32Z

2

One way of doing it would be to use the $redact operator.

Match all the records which have at least one sub document in the name array, which meet our search criteria.
Keep only those sub documents in the name array, which are a match.

snippet:

var minimumAge = 17;
db.t.aggregate([
{$match:{"name.age":{$gt:minimumAge}}},
{$redact:{$cond:[
                 {$gt:[{$ifNull:["$age",minimumAge+1]},
                        minimumAge]},
                        "$$DESCEND",
                        "$$PRUNE"
                      ] 
            }

}
])

answered May 19, 2015 at 19:32

BatScream

19.7k4 gold badges54 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

MongoDB how to return multiple data in an array

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