Studio 3T’s first release in 2018 brings you extended SQL support for GROUP BY, COUNT, MAX, MIN, SUM, and AVG functions, support for additional date formats in CSV imports, and better control for retaining expired operations.

Extended SQL Query Support

SQL Query – the Studio 3T feature that lets you use SQL to query MongoDB – now supports GROUP BY, COUNT, MAX, MIN, SUM, and AVG functions.

Check out the complete feature documentation here and learn more about the currently-supported query criteriaadvanced expressions, and the newly added functions.

Additional Date Format Support in CSV Imports

Go wild with date formatting in your CSV imports. Studio 3T now supports eight date formats:

  • ISO
  • Locale
  • MDY
  • DMY
  • YMD
  • MYD
  • DYM
  • YDM

Read more about the CSV import feature and the supported date formats and separators.

Better Control Over Retained Expired Operations

With Studio 3T 2018.1, you have better control over your expired operations. Define the interval over which your expired ops are retained, now a quick and simple configuration under the Current Operations tab.

Other Improvements and Fixes

You can view the full list in our change log, but here are a few you’ve requested:

  • Count Documents now available in Aggregation Editor
  • Tabs in New / Edit Connection dialogs now scrollable on smaller screens
  • Table View now reverts to correct default view when new projection is used

Do you want something improved in Studio 3T? Or simply want to let us know how we’re doing? We’d love to hear from you!

Download Studio 3T 2018.1

Get the latest version of our MongoDB GUI:

Download Now
Get Download Link for Later