Connections Manager 
Import Wizard 
Collections Tab 
Visual Query Builder 
SQL Query 
SQL Connection Manager 
Team Sharing 
LDAP/ Kerberos
Export Wizard .svg){kind=icon}
SQL to MongoDB.svg){kind=icon}
MongoDB to SQL
Data Compare & Sync 
Task Scheduler 
Intellishell 
Schema Explorer 
AI Helper 
Aggregration Editor 
Query Code 
Query Profiler 
Index Manager 
Visual Explain 
Reschema 
Users and Roles Manager 
Data Masking 
Tag: aggregation
Fixing MongoDB $lookup aggregation
“Why can’t I match anything when I use $lookup?” is a regular question we get to hear. Almost as much as “Why does everything match when I use $lookup?”. Both scenarios are down to innate MongoDB behavior – and once we show you how you’ll never experience these MongoDB $lookup aggregation issues again. Let’s see […]
Posted on: 25/05/2022 • • 3 minutes What is $setWindowFields and why is it so neat?
What is $setWindowFields? Well, $setWindowFields is a new Aggregation stage in MongoDB 5.0. In the most recent release of Studio 3T (2022.2), we added support for it in the Aggregation Editor. Why is it so neat? What it does is completely change what you can do with aggregations, literally opening a window on your documents […]
Posted on: 16/03/2022 • • 4 minutes
Doing Multiple MongoDB Exports At Once With Studio 3T #Studio3T_AMA
Q: Now my boss wants three different spreadsheets generated at the same time? Can I do this without creating a tangle of scheduling? A: Yes you can. In the previous Ask Manatees Anything, we showed you how to turn an export into a scheduled Task. What we didn’t mention was that Tasks are actually containers […]
Posted on: 04/08/2021 (last updated: 21/04/2022) • • 5 minutes
