Tips & Tricks #15 - 'Export MongoDB Query Results'. Want to #export the #results of your query?
By using the Aggregation Editor and an $out Operator, you can export results from Studio 3T. All you need to do is:
- Create a query in Studio 3T via #SQL, the #Aggregation Editor, the IntelliShell, or Visual Query Builder (I use the Visual Query Builder)
- Copy your query into the first stage of the Aggregation Editor.
- Add a second stage in the Aggregation Editor and give a name to the "output-collection"
- Refresh your database
- Right click your new collection and begin to export your query's results (formats include: to another collection, a mongodump, or as SQL, CSV, and JSON files).
Go more in-depth with our Import/Export Feature here: https://studio3t.com/knowledge-base/articles/mongodb-import-export/#import-bson-mongodump-to-mongodb
------------------------------------------------------------------------------------------------------------
New to to the world of #NoSQL and #MongoDB? Studio 3T is the professional #GUI for MongoDB. With its Visual Query Builder, Aggregation Editor, Query Code Translation, and more - Studio 3T makes NoSQL a breeze.
Download now! https://studio3t.com/download/