How to execute update ($set) queries in MongoDB Compass tool?

mongodb mongodb-query mongodb-compass
Patrick picture Patrick · Mar 5, 2018 · Viewed 13.8k times · Source

I'm new to MongoDB Compass tool and am trying to update a field in my collection. Please can someone suggest where the update query must be written. Could find no options or panes in the tool to write custom queries be it selection / updation for that matter.

In the Default Window only the selection/projection/restriction options are found. Any help is much appreciated.

Answer

Ivan Marjanovic picture Ivan Marjanovic · Jul 26, 2018

I had the same issue, it looks like a simple feature to implement (since document updates are possible) but... AFAIK there is no such option in compass, you can do it through mongodb shell (CLI client).

UPDATE: And it seems that it is possible now, although in beta, in the latest version (1.22.1) there is a "_MongoSH Beta" in the bottom left corner of the window. Thx to @Boštjan Pišler for the hint about a new feature.

Related questions

Searching by ObjectId on Mongo Compass

How does one use Mongo Compass and search by ObjectID? I've been searching for the documentation for this but haven't been successful with anything. I have tried: { "_id" : "58f8085dc1840e050034d98f" } { "$oid" : "58f8085dc1840e050034d98f" } { "id" : "58…

Read More
MongoDB Compass filter (query)

In mongoDB compass I am getting no result with the below filters. Not sure what I am doing wrong. {user: {uid: 'ttorone'}} {user: {_id: ObjectId("5b9fc9567a1f050026a8bbda")}} What I want is to filter out this document (…

Read More
How to query MongoDB with "like"?

I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.

Read More