Stack Overflow
Stack Overflow

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

MongoDB Migrate all existing indexes to new database

I have a MongoDB development cluster where i create indexes over time as a part of development improvements. On Testing/Production MongoDB cluster also, i want to maintain the same indexes. So how do i get all indexes of existing collections and…
Stephen
  • 3,359
  • 4
  • 20
  • 30
2
votes
1 answer

Exclude Mongo fields based on regex

My collection has 1000s of fields and I would like to exclude fields that match a certain regex. Several hundred fields are in the form: 'labelXXXX', where XXXX is 4 integers. Is this possible? (i.e. How would I exclude fields from the collection…
yesyoukenn
  • 207
  • 4
  • 17
2
votes
1 answer

MongoDb updateOne not updating results

I am trying to update a record inside a foreach loop. The loop runs and does not produce any errors, but nothing seems to update. db.Collection1.aggregate({ $group:{ _id:"$RecordId", "DateUpdated":{ $max:"$DateUpdated" …
ferensilver
  • 341
  • 2
  • 4
  • 17
2
votes
1 answer

How to optimize C# mongodb query on large datadases?

I have a database table having 100 million records. Screen Shot is taken from Robomongo Table Schema: There are 100 million records When I run the following code. I get results, but It takes around 1 minute to get completed. I need to optimize the…
Umer
  • 21
  • 4
2
votes
0 answers

Change default shell command in the Robomon

Is there any way to change the default shell command in Robomongo which is shown every time a new tab is open? I want shell to show this: db.getCollection('MyCollection').find({}) to…
java_doctor_101
  • 3,287
  • 4
  • 46
  • 78
2
votes
2 answers

roboMongo export to csv output shows bson

I don't have access to mongodb machine. So I cannot run a mongoexport command. Hence I am trying to get my query output to csv format. Query in RoboMongo var cursor = db.getCollection('fineProduct').find ( {"inbuilt.bookingReference" : {…
smilyface
  • 5,021
  • 8
  • 41
  • 57
2
votes
2 answers

Robomongo - How to export aggregation results to a csv file

I have a complex aggregation query in robomongo and I wanna export the results of the query to csv file. Is this doable? How can I do it? I know that this other software Studio3T have that function but it's not free. It has a community version and…
Can Gokalp
  • 115
  • 1
  • 14
2
votes
1 answer

How to aggregate two collections where a field from one collection is greater than the other

I have two collections lets call them collection A and collection B and they both have a price field and item number. so lets say there are 2 items in each: Collection A: name = item1 , price = 30 name = item2 , price = 20 Collection B: name =…
Can Gokalp
  • 115
  • 1
  • 14
2
votes
1 answer

MongoDB: Convert Date String (mm/dd/yyyy) to Unix timestamp

just practicing my MongoDB queries and I've hit a wall with a field data type. I'm currently using Robomongo as GUI for accessing the production database. My document structure looks like: Is there a MongoDB operator or way/method to convert the…
Albert Bahia
  • 21
  • 1
  • 3
2
votes
5 answers

RoboMongo - Cannot Remove Documents from Collection

I'm using RoboMongo to delete a number of documents that match a query. However, it is saying no documents have been delete with the following: db.getCollection('assets').remove( { "source": "red" } ); However, this works perfectly: …
Frog82
  • 464
  • 1
  • 8
  • 25
2
votes
1 answer

how to use variable in update statement - MongoDB

i am trying to use a variable value as column name to update all my documents in a collection. i am trying this through robo mongo shell command. code is below: doc=db.Symbols.findOne(); for (key in doc) { db.getCollection('Symbols').update( {…
shobhit
  • 31
  • 1
  • 4
2
votes
2 answers

MongoDB cursor does not return all documents

Running the following mongo query in RoboMongo (0.9.0-RC09) gives the correct number of documents (using the cursors count function), while iterating all documents does only return a small portion of documents: var allDocuments =…
hupfis
  • 128
  • 7
2
votes
2 answers

How can I search a collection to find a nested value in one of its documents in MongoDB

In the screenshot above you can see that I have open a document named (1) ObjectId(572b...ec7a) from my tests collection in my mongo database. (the tests collection is full of documents like this) Near the bottom of the screenshot you can see there…
GnUfTw
  • 337
  • 1
  • 4
  • 19
2
votes
0 answers

Copy database to another server in mongodb

I am using Robomongo in my local machine. Robomongo is using wired tiger storage engine to store my dbs. Now when I want to copy my database to a remote machine I am using : db.copyDatabase("localDBName","remoteDBName","localMachineAddress") The…
Amriteya
  • 1,118
  • 15
  • 37
2
votes
1 answer

MongoDB Database Error with proper Configuration

I had MongoDB up and running and confirmed that the databases were being added and accessed via RoboMongo on Port 27017. All the database files were being accessed in /data/db. I tried to create a new database and could not get it created. I double…
Mark A
  • 1,995
  • 4
  • 18
  • 26
1 2 3
…
27 28