Projection query n ot working on compass and shell

db.movies.find({genre:“Action,Adventure”},{title:1})

// this query didn’t return anything both on compass and shell

What’s the way forward? thanks and best regards

Hi Ridwan_90696,

Find commands is used for exact match. So, every space character counts. Use this query:

    db.movies.find({genre:“Action, Adventure”},{title:1})

If you are doing copy/paste, and getting this error:

   SyntaxError: illegal character

Then just replace the double quotes.

Kanika