Questions tagged [mongodb-compass]

MongoDB Compass is MongoDB’s own GUI tool for database management, visualization, and CRUD operations. It supports the latest MongoDB versions and is available on Linux, Mac, or Windows. mongodb-compass tag should be used when posting questions related to this tool.

The GUI for MongoDB. Visually explore your data. Run ad hoc queries in seconds. Interact with your data with full CRUD functionality. View and optimize your query performance. Available on Linux, Mac, or Windows. Compass empowers you to make smarter decisions about indexing, document validation, and more.


Development:

All versions of MongoDB Compass are source available and free to use. You can find the source repositories for MongoDB Compass at https://github.com/mongodb-js/compass/.

Running Compass locally requires Node.js and npm:

  • Node.js: ^12.4.0
  • npm: >=6.13.0
npm install
npm start [compass|compass-readonly|compass-isolated]

For issues, create a ticket in JIRA Project.

Is there anything else you’d like to see in Compass? Submit suggestions in our feedback forum.

478 questions
0
votes
1 answer

Can't Filter for Value Inside Array in MongoDB Compass

I have the following record structure: { "_id": { "$oid": "609224f28062c60008143024" }, "attachments": [""], "taggedUsers": [], "parentIds": ["609224f05806bd0008055521"], "user": [{ "email": "mark@place.com", …
0
votes
1 answer

How to compare string feild value in aggregation mongodb

in the following image i am using $project aggregation. i need to compare whether text feild is equals to 'A' or not using $cond. If this boolean condition is true it should return 1 otherwise 0. but it is showing Stage must be properly…
0
votes
1 answer

Mongodb after Indexing Taking Longer execution time

I have 145359 Documents stored in a local MongoDB, which I am trying to index. To speed up my query. { "Categorized": true } Sample Document { "_id" : "dbe14c04-bd1e-454a-af57-4ca61566c0c0", "Categorized" : true, "Archived" : false, …
Taufiq Abdur Rahman
  • 1,348
  • 4
  • 24
  • 44
0
votes
1 answer

Mongodb replace field type

I want to change a field type on mongodb for a collection from BsonBinary to ObjectId I wonder what is the query I should use to convert that field ? By mongodb shell db.company.updateMany({}, {????}) I tried unset then set but still not working
amorenew
  • 10,760
  • 10
  • 47
  • 69
0
votes
0 answers

How to get Mongo Compass to allow editing a specific portion of a document easily?

I am working with Mongo Compass as part of a proof of concept. I have a document that has a large object array within it I wish to edit. When I click the edit button, the cursor is sent an arbitrary line in the document, regardless of where I…
Timbuck
  • 233
  • 4
  • 13
0
votes
1 answer

Unable to access result of $addFields in $lookup in MongoDB Aggregate function

I have a aggregation function in which there are nested lookups with pipeline. In one of the pipeline I have the following - { "$addFields": { "ids": { "$split": ["$id", ","] } } }, { "$lookup": { "from": 'collection2', "let":…
0
votes
1 answer

MongoDBCompass not opening on Windows Server 2019

I have installed MongoDB on one windows server 2019 and am able to access it using shell commands but when I try to launch MongoDB Compass software, it doesn't even launch. It shows up in the task manager but UI never comes up Windows Server is 64…
Ankit
  • 6,388
  • 8
  • 54
  • 79
0
votes
1 answer

Where are aggregation pipeline saved in MongoDb Compass?

I know that starting from Compass 1.21 saved aggregation pipelines are moved to filesystem as stated here, but I was not able to find where!! What am I missing?
EanX
  • 475
  • 4
  • 21
0
votes
1 answer

MongoDB Compass: How to filter embedded array object in the MongoDB document

I want to filter the documents based on importkeyid and MissingPersonIds.PhotoId array field. The filter on MissingPersonIds.PhotoId should work like 'sql - like' operator. Schema: [{ "_id": { "$oid": "61ada7da9a30fd8471869bbc" }, …
Abhishek Vyas
  • 599
  • 1
  • 9
  • 24
0
votes
1 answer

MongoDB: Creating a calculated field measuring the difference between date fields

Context This question uses the same collection/ document schema construct from my other question: MongoDB: Creating calculated fields using the switch function (column aliasing) Data Schema Note: cal_date1 is the calculated value shown in my other…
Curious
  • 325
  • 1
  • 10
0
votes
2 answers

MongoDB: Creating calculated fields using the switch function (column aliasing)

Note I am completely new to MongoDB so my terminology might not be fully correct. Context I have some data with various dates in MongoDB and I am trying to use a $switch function to provide column aliasing to form some new calculated columns however…
Curious
  • 325
  • 1
  • 10
0
votes
1 answer

Mongo DB Error while Updating - error on remote shard - caused by cursor id

I have about 8 Million Documents in my Collection. And I want to remove the special Characters in one of the fields. I will post my Statement below. I am using the mongo shell in the Mongo db compass tool. The update is working about 30-50 Minutes…
Swoop
  • 49
  • 1
  • 10
0
votes
1 answer

Update one or two fields in an array for all documents in a collection - mongo db

First of all, I am using Mongo DB Compass and the mongo shell. I want to update for example this field: 1List.Comment In this Field I want to replace 'ß' with 'ss' 1List is an array. And in this Array I can have several Objects. These Objects…
Swoop
  • 49
  • 1
  • 10
0
votes
1 answer

How to sum the length of particular array field present in all objects inside an array in mongodb document

This is the sample of my mongodb document( try to use jsonformatter.com to analyse it): {"_id":"6278686","playerName":"Rohit…
0
votes
1 answer

How to sum a particular number field present in all objects inside an array in mongodb document

This is the sample of my mongodb document( try to use jsonformatter.com to analyse it): {"_id":"6278686","playerName":"Rohit…