Urgent Please : movieDetails collection is empty

Hi

I dont know how but my movieDetails Collection is showing only id…

Today is the last day of submission of exam and I am unable to solve the Question 6.

Pls help urgently

Vineet Midha

Did you use any filter?
It should show all fields
MongoDB Enterprise Cluster0-shard-0:PRIMARY> use video
switched to db video
MongoDB Enterprise Cluster0-shard-0:PRIMARY> show collections
movieDetails
moviesScratch
MongoDB Enterprise Cluster0-shard-0:PRIMARY> db.movieDetails.count()
2295

MongoDB Enterprise Cluster0-shard-0:PRIMARY> db.movieDetails.find().limit(3).pretty()
{
“_id” : ObjectId(“5c4d2110dd0c40e56fbc3904”),
“title” : “Once Upon a Time in the West”,
“year” : 1968,
“rated” : “PG-13”,
“runtime” : 175,
“countries” : [
“Italy”,
“USA”,
“Spain”
],
“genres” : [
“Western”

1 Like

Thanks for reply.

I disconnected and reconnected the compass and same I did at the command prompt.

Now, the movieDetails is showing the fields. But, it does not contain the fields as is required as per Question 6 … viewerRating and mpaaRating

  • The cast includes either of the following actors: “Jack Nicholson”, “John Huston”.
  • The viewerRating is greater than 7.
  • The mpaaRating is “R”.

My query does not give any result because there are no fields in the collection. Am I missing something ?

Oh hell… my mistake.

I was looking at movieDetails collection, whereas the question pertains to movies collection.

Issue solved.

Thanks for the your concern.