What’s New in Studio 3T 2021.10 | Value Search, Better Task Scheduling and Import Data Masking

Headline features in Studio 3T 2021.10

Value Search is a brand new feature in Studio 3T 2021.10 which lets you ask the question “Where is X referred to in my server, database or collection?”. It’s a global search of all the values in the fields in your system. You set the scope – server, database, or collection – and Studio 3T will dig through every field looking for your value or matches to your regular expression. 

In the example above, we are value searching for the word WELCOME in uppercase (so match case is on) and as you can see from the results, the search runs across documents in multiple databases and collections, and digs down into arrays and embedded documents within those documents. 

You’ll find Open Value Search under the File… menu or on the right-click menu of any server, database or collection in the Connection Tree.

Task Scheduler is now able to schedule events in a more precise way. To go with this change, we’ve refreshed the Task Scheduler interface, giving it more configuration options. You can now configure a Task to run Once, Daily at a particular time, Every number of minutes or hours, Weekly on particular days, Monthly or in a Custom configuration combining all the previous options. It’s very flexible. For example, you can configure a task to be run on particular days of the month, every 20 minutes, between the hours of 11am and 1pm, and also every Friday. 

To make it easy to see what you have configured, every option gives you a schedule summary which will explain what has been scheduled. 

Import Data Masking is now available in Studio 3T. Previous versions have supported Data Masking on exported data. With Import Data Masking, you get the ability to obscure, shuffle or exclude fields from imported data at the point of import. That improves your data hygiene and compliance as you can now ensure sensitive information is never stored in the database and doesn’t leak into your backups. 

Other Improvements in Studio 3T 2021.10

Connection Tree performance when dealing with hundreds of collections or connections, making it faster to traverse and ensuring Studio 3T stays responsive.

Connection Search, within the Connection Tree, now has a button that can enable case sensitive searches of the Connection Tree. Now if you really want to find collections called dbAdmin, you can search for dbAdmin and make the search case sensitive so you don’t see admin, dbadmin or DBadmin.

Improved JavaScript Support has been integrated into Studio 3T 2021.10. This includes allowing a wider range of JavaScript syntax to be accepted as valid by the Studio 3T editor. By doing this, we’re unlocking capabilities in the underlying Mongo shell, such as spread operators (the … syntax for expanding arrays) and other JavaScript features (from ES6 onwards) which are available in various versions of the Mongo shell. This development is part of the work we are doing to support the following feature.

Experimental Mongosh Support is a first step in bringing the latest Mongo command line shell to Studio 3T.  Users can download and install Mongosh and then set Studio 3T’s preferences to use it rather than the bundled Mongo shell as the underlying shell for IntelliShell. As an experimental release, Mongosh support does not include Query Assist, so any results returned by using the support will not be inline editable.

User Shoutouts

We’d like to thank the users of Studio 3T who have yet again been invaluable to making Studio 3T better for them and everyone else. 

For this release, those thanks go out to Dean Mann and Joseph Leiba who spotted problems opening saved aggregation queries, Michael Swanson for noting that window sizes weren’t being saved, a.n.Other Michael found an issue with the StorageEngine setting and indexes, Sergey Ivasenko for finding that horizontal Intellishell windows weren’t restoring, Ken Whipday for identifying a possible exception, Pramod Anchuparayil for suggesting users be able to continue editing after insert/update failed, Jayant Agarwal for locating a problem with Step Into Cell and Bill Robinson for reporting a lack of “Save your Changes”. 

For obvious reasons, we like to clear peoples inclusion in this list, but sometimes things go a little out of sync. Last month, we headlined the Visual Query Builder’s automatic popup, and now, we are free to thank Chris Ellis for suggesting that splendid enhancement.

New in Studio 3T 2021.10

Database Copy: It is now possible to copy entire databases and multiple databases and paste them into other servers.

Improved

Collections View: Add/Edit document now lets you continue to work on a document after the server rejected it.

Fixed

General: The application was not prompting on exit to save your changes when there were unsaved changes.

Aggregation Editor: Certain scripts could not be loaded from a file or the clipboard.

Index Tab: The “storageEngine” setting in index definitions was not preserved when updating an index definition.

IntelliShell: Issues found when restoring Intellishell windows which had been flipped to horizontal.

Exports: A possible error around Incremental Execution was found when using existing export configurations.

Results View: Stepping into a cell failed when the document IDs were not unique.

For the full history of changes in Studio 3T, see the change log.