I insert a document in a sharded collection using nodejs driver. I can update it using nodejs driver. I can't update it using compass gui.
I get the error "Query for sharded findAndModify must contain the shard key". But the record does contain the shard key and everything is valid. I don't know which query compass is sending, but it seems erratic.
I don't know. Maybe a simple sharded collection, sharded with method HASHED.
It should update.
Update is denied with the error "Query for sharded findAndModify must contain the shard key".
Please see the screenshots. The collection "appointment" is sharded on "_where._location._country._locId" with the method "HASHED". It should work.