Tag: AMA

Studio 3T logo

How do I analyze the schema of some of my documents. #Studio3T_AMA

Q: I have a collection with assorted documents, but I only want to analyze the schema of documents that have a particular field. How can I do this with Studio 3T and are there any shortcuts? A: If you run the Studio 3T Schema Explorer tool, you will notice that there is a field labeled […]

Posted on: 18/01/2023 • Dj Walker-Morgan 2 minutes

Ask Manatees Anything – AMA Annual Answers

Over the Year, the Ask Manatees Anything (AMA) team have been offering answers your questions. Questions gleaned from near, far, from the [email protected] mailbox and from the Studio 3T Community forum. Studio 3T AMAs are all about explaining everything around Studio 3T and MongoDB. Here’s some of the questions and answers from the past year […]

Posted on: 20/12/2022 • Dj Walker-Morgan 2 minutes
Studio 3T logo

AMA: Setting an SQL Migration primary key

Q: How do I set the primary key in a Studio 3T Migration from MongoDB to SQL? I want to set my own primary key field name and start it at a specific value. A: You can set your SQL primary key through the Migration Mappings interface. When you do an SQL Migration with Studio […]

Posted on: 14/11/2022 • Dj Walker-Morgan 2 minutes
Studio 3T logo

What does the “Query Options” button in Studio 3T do? #STUDIO3T_AMA

Q: What does the “Query Options” button in Studio 3T do? Quick answer:  The Query Options button makes it easier to turn on disk use and set the collation for a find query. Longer answer:  The Find Query Options dialog is displayed when the icon next to the run query button – in the Collections […]

Posted on: 18/08/2022 (last updated: 24/08/2022) • Dj Walker-Morgan 2 minutes
Studio 3T logo

How can I trim a string prefix in MongoDB Aggregation? #Studio3T_AMA

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.

Posted on: 03/08/2022 (last updated: 27/08/2024) • Dj Walker-Morgan 3 minutes
Studio 3T logo

How do I give Studio 3T feedback? I want to tell them what I want. #Studio3T_AMA

How do you let us know what you want or need in Studio 3T? Through feedback and in this AMA, we look at the three routes to letting us know what you think.

Posted on: 13/07/2022 • Dj Walker-Morgan 3 minutes

How to get MongoDB statistics for all collections? #Studio3T_AMA

Learn how to harness the power of MongoDB scripting with Studio 3T’s Intellishell as we show how to gather your collection statistics for all your databases in this Ask Manatees Anything article.

Posted on: 06/07/2022 • Dj Walker-Morgan 3 minutes

The Value of a Regular Expression: #Studio3T_AMA

Q: I was using Value Search in Studio 3T, searching for “test” and I noticed the Regular Expression checkbox on the search window. Checking it made no difference to the results of my searches so what does it actually do? A: The reason you aren’t seeing any difference in your search results is because your […]

Posted on: 15/06/2022 • Dj Walker-Morgan 4 minutes
3T - MongoDB Tools

What’s a covered query in MongoDB? #Studio3T_AMA

What is a covered query in MongoDB? What makes them fast queries? How do you know you have one? And how do you make one? All these questions answered in this Ask Manatees Anything.

Posted on: 27/04/2022 • Dj Walker-Morgan 3 minutes