How do I query a nested object in MongoDB?

Question

I have a JSON schema that looks like this:

{
    "_id" : ObjectId("5692a3e124de1e0ce2dfda22"),
    "title" : "A Decade of Decadence, Pt. 2: Legacy of Dreams",
    "year" : 2013,
    "rated" : "PG-13",
    "released" : ISODate("2013-09-13T04:00:00Z"),
    "runtime" : 65,
    "countries" : [
            "USA"
    ],
    "genres" : [
            "Documentary"
    ],
    "director" : "Drew Glick",
    "writers" : [
            "Drew Glick"
    ],
    "actors" : [
            "Gordon Auld",
            "Howie Boulware Jr.",
            "Tod Boulware",
            "Chen Drachman"
    ],
    "plot" : "A behind the scenes look at the making of A Tiger in the Dark: The Decadence Saga.",
    "poster" : null,
    "imdb" : {
            "id" : "tt2199902",
            "rating" : 8,
            "votes" : 50
    },
    "awards" : {
            "wins" : 0,
            "nominations" : 0,
            "text" : ""
    },
    "type" : "movie"
}

I am trying to find a movie released in 2013, that is rated PG-13 and has won no awards. I tried the following query in my Mongo Shell but no luck:

db.movieDetails.find({rated: "PG-13", year:2013, awards: { wins : 0}})

Any ideas?

Sede · Accepted Answer · 2016-01-15 22:44:36Z

2

From the documentation:

When the field holds an embedded document, a query can either specify an exact match on the embedded document or specify a match by individual fields in the embedded document using the dot notation

db.movieDetails.find( { "rated": "PG-13", "year": 2013, "awards.wins" : 0 } )

answered Jan 15, 2016 at 22:44

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

Comments

yftse · Accepted Answer · 2016-01-15 22:37:17Z

0

if this PG-13 rating query would work for you:

db.movieDetails.find({"rated": "PG-13"})

then i would try something like this:

db.movieDetails.find({$and: [{"rated": "PG-13"}, {"year": 2013}, {"awards": { "wins" : 0}}]} )

answered Jan 15, 2016 at 22:37

yftse

1936 bronze badges

1 Comment

yftse Over a year ago

does this one without the awards work? db.movieDetails.find({$and: [{"rated": "PG-13"}, {"year": 2013}]} )

Collectives™ on Stack Overflow

How do I query a nested object 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