Trimming 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.
“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? 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 […]
What 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
Is your Studio 3T not showing explain statistics for aggregations? Find out why aggregations are different in Ask Manatees Anything #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 […]
Studio 3T went to London as sponsors of MongoDB Europe 2018, the biggest MongoDB event on this side of the Atlantic. Here’s a recap.
With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data. Please choose for which purposes you wish to give us your consent and store your preferences by clicking on “Accept selected”. You can find further information in our Privacy Policy.
Essential cookies are strictly necessary to provide an online service such as our website or a service on our website which you have requested. The website or service will not work without them.
Performance cookies allow us to collect information such as number of visits and sources of traffic. This information is used in aggregate form to help us understand how our websites are being used, allowing us to improve both our website’s performance and your experience.
Functional cookies collect information about your preferences and choices and make using the website a lot easier and more relevant. Without these cookies, some of the site functionality may not work as intended.
Social media cookies are cookies used to share user behaviour information with a third-party social media platform. They may consequently effect how social media sites present you with information in the future.
