Tag: aggregation
How can I trim a string prefix in MongoDB Aggregation? #Studio3T_AMA
Posted on: 03/08/2022 (last updated: 24/08/2022) by Dj Walker-MorganTrimming a prefix rom a string during aggregation should be simple, but there’s no out of the box operator to do it. In this AMA, we show you how.
Fixing MongoDB $lookup aggregation
Posted on: 25/05/2022 by Dj Walker-Morgan“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 […]
What is $setWindowFields and why is it so neat?
Posted on: 16/03/2022 by Dj Walker-MorganWhat 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 […]
I don’t get unwind in aggregation – why do I need it?
Posted on: 01/12/2021 by Dj Walker-MorganWhat does it mean to unwind in MongoDB Aggregation? And what’s that got to do with arrays? Find out in the latest Ask Manatees Anything #Studio3T_AMA
Where’s my full Studio 3T Aggregation Explanation? #Studio3T_AMA
Posted on: 02/09/2021 (last updated: 22/02/2022) by Dj Walker-MorganIs your Studio 3T not showing explain statistics for aggregations? Find out why aggregations are different in Ask Manatees Anything #Studio3T_AMA
Doing Multiple MongoDB Exports At Once With Studio 3T #Studio3T_AMA
Posted on: 04/08/2021 (last updated: 21/04/2022) by Dj Walker-MorganQ: 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 […]
MongoDB Europe 2018: An Aggregation
Posted on: 15/11/2018 (last updated: 02/07/2021) by Kathryn VargasStudio 3T went to London as sponsors of MongoDB Europe 2018, the biggest MongoDB event on this side of the Atlantic. Here’s a recap.
Tags
Browse by MongoDB topic
- Connecting to MongoDB
- Database Administration & Security
- Getting Started with MongoDB
- Getting Started with Studio 3T
- Import/Export
- Job Automation & Scheduling
- MongoDB Aggregation Framework
- MongoDB/Studio 3T Workshops
- Performance
- Query & CRUD Operations
- Reference
- Schema
- Studio 3T Licensing
- Support and other resources
- Working with MongoDB & SQL
- Working with MongoDB Atlas