How to query element in array of arrays in MongoDB?

Question

I'm learning MongoDB on my own. I have a collection with entries that look like this:

{
"_id" : ObjectId("5d0c13fbfdca455311248d6f"),
"borough" : "Brooklyn",
"grades" : 
    [ 
        { "date" : ISODate("2014-04-16T00:00:00Z"), "grade" : "A", "score" : 5 },
        { "date" : ISODate("2013-04-23T00:00:00Z"), "grade" : "B", "score" : 2 },
        { "date" : ISODate("2012-04-24T00:00:00Z"), "grade" : "A", "score" : 5 }
    ],
"name" : "C & C Catering Service",
"restaurant_id" : "40357437"
}

And I want to find all restaurants in Brooklyn with at least one grades.grade of A.

I've figured out the first half of the puzzle:

db.restaurants.find({borough:{$eq:"Brooklyn"}})

But how do I query in the "grades" array for grade A?

Mạnh Quyết Nguyễn · Accepted Answer · 2019-06-21 02:43:06Z

2

Use dot (.) to access and query nested objects:

db.restaurants.find({'borough':{$eq:"Brooklyn"}, 'grades.grade': 'A'})

edited Jun 21, 2019 at 2:43

answered Jun 21, 2019 at 2:27

Mạnh Quyết Nguyễn

18.3k1 gold badge28 silver badges54 bronze badges

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

Comments

4b0 · Accepted Answer · 2019-06-21 08:16:23Z

0

db.restaurants.find({"borough" : "Brooklyn","grades.grade":"A"})

edited Jun 21, 2019 at 8:16

4b0

22.4k30 gold badges97 silver badges143 bronze badges

answered Jun 21, 2019 at 8:15

Kavi Ponnusamy

313 bronze badges

1 Comment

4b0 Over a year ago

While this code may solve the question, including an explanation really helps to improve the quality of your post.

Collectives™ on Stack Overflow

How to query element in array of arrays in MongoDB?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related