Query & CRUD Operations

Search In… (aka Value Search) Tool/Feature Documentation

Posted on: 23/06/2022 (last updated: 04/04/2024) by Dj Walker-Morgan

About Search In… Search In… or Value Search is a wide-range text search on the values stored in a MongoDB collection, database, or server. By default, it scans all documents for text matches (or regular expression matches) in all field values and field names. Search In… scans embedded documents and arrays and shows you the […]

Date Tags Tool/Feature Documentation

Posted on: 21/04/2022 (last updated: 30/09/2024) by Dj Walker-Morgan

Date tags are placeholders for different date operations relative to when a query is run. Date tags make date fields easier to work with by saving you from having to perform calculations with the MongoDB Date() function. Studio 3T converts the date tags when the query is run into the appropriate MongoDB query, using greater than and […]

Data Compare and Sync Tool/Feature Documentation

Posted on: 04/12/2020 (last updated: 17/10/2022) by Kathryn Vargas

Data Compare and Sync shows the differences between any two MongoDB collections side-by-side for an easier, more visual data comparison.

How to Find & Filter MongoDB Array Elements Using $elemMatch Tutorials

Posted on: 16/10/2020 (last updated: 13/03/2024) by Juan Roy Couto

Learn how to filter elements from arrays in MongoDB by using the $elemMatch operator alongside find(), $match, and the $project and $filter functions.

Query Manager Tool/Feature Documentation

Posted on: 15/10/2020 (last updated: 13/02/2024) by Kirsty Burgess

Query Manager keeps track of all your MongoDB queries in Studio 3T and allows you to organize your queries and scripts into folders. You can access Query Manager from the Collection Tab, IntelliShell, SQL Query, the Aggregation Editor, or the My resources sidebar. Displaying the Query Manager To display the Query Manager, click Load Query and […]

How to Query MongoDB Arrays Without Using the mongo Shell Tutorials

Posted on: 14/08/2020 (last updated: 04/08/2021) by Robert Sheldon

In this tutorial, learn how to query MongoDB arrays and filter array string values using Studio 3T’s drag-and-drop Visual Query Builder.

The Quickest Way to Change a Field Type in MongoDB Tutorials

Posted on: 10/06/2020 (last updated: 30/08/2021) by Kathryn Vargas

Learn how to change a field type in MongoDB in a single document or across all documents in your collection.

Aggregation Editor Tool/Feature Documentation

Posted on: 02/06/2020 (last updated: 13/02/2024) by Kirsty Burgess

Take a look at how to build aggregation queries stage-by-stage with the Aggregation Editor, starting with this example that uses $match, $group and $sort.

How to Copy a MongoDB Collection to Another Database Tutorials

Posted on: 29/04/2020 (last updated: 19/06/2024) by Kirsty Burgess

Copy a MongoDB collection to another database in a few clicks using Studio 3T’s convenient built-in copy and paste features.

How to Copy and Paste MongoDB Documents Tutorials

Posted on: 23/04/2020 (last updated: 09/03/2022) by Thomas Zahn

Learn how to copy and paste MongoDB documents across Studio 3T.