Support of hint via the VSC extension to a 3.6 version of MongoDB?


So I tried this query out via the VSC Exension and got an error back, talking about “planner returned error: bad hint”.

  {"$match": {"year": { "$gt": 2010}, "countries": "Costa Rica"}},
  {"$sort": {"title":1}}],
  {"hint":{"countries": 1}, "explain": true}

Any thoughts on what’s not right? Is it that the movies db doesn’t have a countries index?


EDIT: Yes, the additional of the index, sorted the problem out :slight_smile: