Questions tagged [robo3t]

Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool.

The Robo 3T (formerly Robomongo) is a shell-centric cross-platform MongoDB management tool. Unlike most other MongoDB admin UI tools, Robo 3T embeds the actual mongo shell in a tabbed interface with access to a shell command line as well as GUI interaction.

Useful links

416 questions
2
votes
1 answer

How to pass results from one query to another in Robo3T

I'm trying to pass the results from one MongoDB query to another but the results are in Object and I need it as an Array. Example: var locId = db.getCollection('locations').find({country:"France"}, {_id:1}).toArray() How can I pass the results to…
Ivo Hristov
  • 83
  • 1
  • 5
2
votes
1 answer

Get total users list along with the active users in mongodb matched on OR condition

Table : user: A, active_1 : "true", active_2 : "false", is_user : "true" user: B, active_1 : "false", active_2 : "true", is_user : "true" user: C, active_1 : "false", active_2 : "false", is_user : "true" Expected Output: { "_id" : null, …
Navi
  • 1,000
  • 1
  • 14
  • 44
2
votes
0 answers

Can't connect Robo3T to Google Cloud Platform compute engine via SSH

I can SSH into my instance from the terminal like this: ssh -i @ But I can not connect Robo3T via an SSH tunnel, using the same credentials - I get the error: Resource temporarily unavailable.…
2
votes
2 answers

Sort MongoDB Document by field/key name

I'm reviewing my MongoDB documents using Robo 3T, and I'd like to sort the keys in the document by their name. My document might look like {"Y":3,"X":"Example","A":{"complex_obj":{}} and at the end I'd like the returned document to look like when I…
ADataGMan
  • 449
  • 1
  • 7
  • 23
2
votes
1 answer

Convert UUID to String for insert in mongodb

Upon trying the following code: db.getCollection('col').find({}).forEach(function(doc){ var id = new UUID().toString(); // this doesn't work, neither does 'var id = new UUID();' db.getCollection('pubCol') …
Naman
  • 27,789
  • 26
  • 218
  • 353
2
votes
1 answer

How can I connect to AWS Documentdb with Robo 3T?

Using the latest Robo 3T and the command line provided by AWS mongodb://:@example-db.cluster-c2e1234stuff0e.eu-west-2.docdb.amazonaws.com:27017 I get this Error: Reason: SSL tunnel failure: Network is unreachable or…
Blobafet
  • 419
  • 1
  • 7
  • 13
2
votes
4 answers

Mongodb query to return field value

I am trying to construct a Mongodb query to return a field value. My JSON looks like this: "question" : "Global_Deployment", "displayOrder" : 1, "answerOptions" : { "fieldId" :…
Pismotality
  • 2,149
  • 7
  • 24
  • 30
2
votes
2 answers

Robo3T Does not show the database

I can connect to a MongoDB Atlas replica set but it has no database. When I click the master node, it shows a new shell And I can find the objects with db.getCollection('aCollection').find() How can I show/add the database in the left pane? ps. I…
Kennyhyun
  • 1,032
  • 1
  • 10
  • 14
2
votes
0 answers

How can I set database authentication in Mongodb - Is SSH Pipes better for MongoDB?

I have installed MongoDB in my computer. I did't define any password and username for the installation. I can see everything with Robo 3T. Now I want to protect my database. I have tried to set authentication for the database. I followed…
userAsk
  • 125
  • 1
  • 8
2
votes
1 answer

How to merge documents on a grouping condition and create a new field in mongo collection?

It is a data migration in a mongo db collection. It is a data migration in a mongo db collection. In the code below, I have some documents. On the basis of common field1, all the documents should be grouped and merged to a single document. In the…
Kusum
  • 241
  • 5
  • 20
2
votes
1 answer

How to convert MongoDb query into csv (excel format)

This is my query. I would like to export the output of this query into csv (excel format) so i can have a table of data. How can i do this? I am using Robo3t. (db.getCollection('sentimentOpinions').aggregate([ { $match : { objectType : "Security"…
ARJ
  • 21
  • 5
2
votes
3 answers

MongoDB query returning no results

I'm new to mongo and am trying to do a very simple query in this collection: { "_id" : ObjectId("gdrgrdgrdgdr"), "administrators" : { "-HGFsfes" : { "name" : "Jose", "phone" : NumberLong(124324) }, …
WilsonPena
  • 1,451
  • 2
  • 18
  • 37
2
votes
1 answer

Trying to insert current date / ISODate() into MongoDB using RoboMongo

I am currently using RoboMongo to insert documents into my MongoDB collection. At times, I also need to make updates as well. My documents have two fields are causing me issues: createdDate and updateDate What I would like to do is provide the…
syedfa
  • 2,801
  • 1
  • 41
  • 74
2
votes
1 answer

Robo 3T SaslFailed

I am trying to connect to my Azure CosmoDB This is the error I get: SSL connection failure: SaslFailed I cant seem to find any information about this error. When I try to login using Studio 3T with the same login inputs, it works (however, this…
mathkid91
  • 659
  • 2
  • 10
  • 27
2
votes
1 answer

db connection path to connect application that is running in docker

I am running nodejs application in docker. In that application I am trying to connect my system database. But It is not working In my environment file: **MONGODB_URI=mongodb://192.168.1.174:27017/sampleDB** SESSION_SECRET=sample App_PORT =…
N15
  • 305
  • 2
  • 4
  • 17