Unexpected output

Mansha_16263 · October 27, 2018, 6:57am

Good morning kanika mam

plzz help me with this .

Tess_Sluijter · October 27, 2018, 4:59pm

The most important question is, “what do you want help with”?

What is the problem you’re experiencing?
Why is this output not what you expected?
What did you expect to happen?
What did you do to produce this output?

Kanika may know a lot, but they’re not a mind-reader

spy_spy_spy · October 27, 2018, 5:51pm

db.movieDetails.find({rated: {$nin: ["PG", "R"]}}, {title: 1, rated: 1}).pretty()

Mansha_16263 · October 28, 2018, 7:12am

thanks for replying.
but i wanna know why my solution is incorrect. there must be some hidden concept.

spy_spy_spy · October 28, 2018, 2:20pm

If you want to multiple conditions on the same field you need to use $and (in some cases $in/$nin) operator. Otherwise you only query on last condition ($ne: “R” is your case).