Skip to content
Studio 3T - The professional GUI, IDE and client for MongoDB
  • Tools
    • Aggregation Editor
    • IntelliShell
    • Visual Query Builder
    • Export Wizard
    • Import Wizard
    • Query Code
    • SQL Query
    • Connect
    • Schema Explorer
    • Compare
    • SQL ⇔ MongoDB Migration
    • Data Masking
    • Task Scheduler
    • Reschema
    • More Tools and Features
  • Solutions
  • Resources
    • Knowledge Base
    • MongoDB Tutorials & Courses
    • Tool/Feature Documentation
    • Reports
    • Case Studies
    • Whitepapers
    • Blog
    • Testimonials
    • Community
  • Contact us
    • Contact
    • Sales Support
    • Feedback and Support
    • Career
    • About Us
  • Store
    • Buy Now
    • Preferred Resellers
    • Team Pricing
  • My License
  • Download
search

What’s New in Studio 3T 2020.9 | Query Manager, Elapsed Time Indicator & More

Posted on: 15/10/2020 (last updated: 06/08/2021) by Kathryn Vargas

2020.9.3 update: Added proxy authentication support for License Manager connections, fixed issues with SRV connections and JSON formatting
2020.9.2 update: Fixed a crash that could occur while using Query Manager and bookmarks created with Studio 3T versions older than 2019.7
2020.9.1 update: Fixed an issue that could lead to crashes on macOS

Find query history and bookmarks under Query Manager, an elapsed time indicator for running queries, and more.

New features

Query History and Bookmark Manager | Now under one roof

In case you’ve overlooked these powerful features, it’s the best time to dust them off. Now you can view your bookmarked queries and search through your query history in one place.

The History tab of Query Manager

We’ve also included a last “Executed date and time” column in the History tab and a “Last modified date and time” column in the Bookmarks tab to help you identify your queries more easily.

Find the History and Bookmarks tabs in the Query Manager, which you can access in SQL Query, IntelliShell, Aggregation Editor, and the Collection Tab by either clicking on the ellipsis or star icons at the top-right corner.

Find Query Manager across Studio 3T features


Read more about the Query Manager here.

App-wide | Show elapsed time for running queries

Are your queries taking longer than expected? You can now see how much time has elapsed for any given query at the bottom-right corner of the SQL Query, Aggregation Editor, Map-Reduce, IntelliShell and the Collection Tabs.

Elapsed time indicator for queries

Connection Manager | A better way of displaying databases

We’ve added two additional checkbox options in the Connection Manager to help you control which databases to display in the Connection Tree.

(NEW) Always show the authentication database of the user account – Checking this box will always show the authentication database in the Connection Tree.

(NEW) Always show all databases defined in roles of the user – Checking this box will additionally always show any other databases that your user privileges allow, e.g. databases that contain collections your user privileges grant you access to.

Manually list additional visible databases by their names – In most cases, Studio 3T will automatically list the databases that should be visible to non-admin users. In some cases when this information isn’t available, you can check the box and manually specify them here.

New options in Connection Manager

View the full Connection Manager documentation here.

Fixes and improvements

User shout-outs

Many thanks to David Henderson for flagging the issue with color-coding in the Connection Tree on Linux; Keith Lancaster for pointing out that custom primary and foreign key names were being ignored during execution in MongoDB to SQL Migration; YuQiang Yuan for reporting the issue when typing Chinese characters in editors; and everyone else who contributed to this release 🙂

App-wide

  • Fixed issue where “Copy Database” would continue to copy views, even after it has been cancelled
  • Improved in-app feedback mechanism, now auto-filling fields
  • Fixed issues that could occur when typing Chinese characters in editors
  • Improved messaging under Preferences > Proxy to warn about missing proxy support on IntelliShell

Aggregation Editor

  • Added support for $unionWith stage
  • Stage operators now shown in the stage tabs for easier navigation
  • Fixed code formatting issues in the stage editor

Collection Tab

  • [Windows only] Fixed hotkey functionality for Expand and Expand Recursively when multiple documents are selected
  • Improved the Multi-line query editor UX to match those found in other places (e.g. now supports indentation, insertion of spaces instead of tab stops)

Connection Manager

  • Now automatically detects and parses connection strings from MongoDB Compass
  • Now displaying a security reminder when “None” or “Legacy” is chosen as the authentication method
  • [Ubuntu only] Fixed status colors in the Test Connection window
  • Fixed parsing issue with NoSQLBooster connection strings
  • Fixed SRV connections that failed when configured to use a custom Root CA certificate

Connection Tree

  • Fixed issue with collections being removed in the Connection Tree, even though they haven’t been dropped due to missing permissions
  • [Ubuntu only] Fixed issue with color-coded connections

Dark Theme

  • Improved readability of the selected task’s name in the Task Manager
  • [macOS only] Fixed visual glitch in Visual Query Builder during certain hover actions

Data Compare and Sync

  • Fixed color transparency levels in the Comparison Unit table

Export Wizard

  • Fixed crash that could occur when running an export task after closing all of its unit tabs
  • Improved UX when invalid input is detected while editing the query of an export unit

MongoDB to SQL Migration

  • Fixed issues where custom primary and foreign key names were ignored during execution
  • Improved in-app tutorial

Session Restore

  • Fixed a crash that could occur when closing all tabs with multiple SQL Migration tabs open
  • Fixed issue of Export unit subtabs being restored incorrectly

SQL Query

  • Now allowing queries that translate to $lookup stages to be run on sharded clusters

SQL to MongoDB Migration

  • Improved in-app tutorial

Tasks

  • Brought back confirming and closing “Save Task” dialogs with the Enter key
  • [Ubuntu only] Fixed UI issues when highlighting a cell in the Status column; icons also now showing when a task is selected

Visual Query Builder

  • Now preventing drag-and-drop of fields with unsupported data types from the Result tab into the builder, showing a message dialog instead

View the full list on our change log.

Download Studio 3T

Auto-update in the app, or start your free 30-day trial today:

Try Studio 3T 2020.9

How helpful was this article?
This article was hideous
This article was bad
This article was ok
This article was good
This article was great
Thank you for your feedback!

About The Author

Kathryn Vargas

When she's not writing about working with MongoDB, Kathryn spends her free time exploring Berlin's food scene, playing the drums, learning languages (current mission: German), and hiking.

Related articles

  • What’s New in Studio 3T 2020.3 | Improvements to Session Restore, Connection Manager & More
  • What’s New in Studio 3T 2020.4 | Introducing License Manager, IBM DB2 Migration Support, Export Wizard Improvements
  • What’s New in Studio 3T 2020.5 | Password Encryption via Cryptographic Key Store, Custom SQL Migration Imports & More
  • What’s New in Studio 3T 2020.7 | Export Documents from Table View to CSV, Edit find() Queries During Export & More
  • What’s New in Studio 3T 2020.2 | Aggregation Editor Revamp, Export Wizard + Tasks Integration & More

Tags

academy aggregation AMA atlas community connections date tags events export features hackolade import intellishell JSON knowledge base migration modelling mongodb mongoodb productivity query regex releases schema security SQL Studio 3T tasks tips updates webinar windows

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

Studio 3T

MongoDB Enterprise Certified Technology PartnerSince 2014, 3T has been helping thousands of MongoDB developers and administrators with their everyday jobs by providing the finest MongoDB tools on the market. We guarantee the best compatibility with current and legacy releases of MongoDB, continue to deliver new features with every new software release, and provide high quality support.

Find us on FacebookFind us on TwitterFind us on YouTubeFind us on LinkedIn

Education

  • Free MongoDB Tutorials
  • Connect to MongoDB
  • Connect to MongoDB Atlas
  • Import Data to MongoDB
  • Export MongoDB Data
  • Build Aggregation Queries
  • Query MongoDB with SQL
  • Migrate from SQL to MongoDB

Resources

  • Feedback and Support
  • Sales Support
  • Knowledge Base
  • FAQ
  • Reports
  • Case Studies
  • White Papers
  • Testimonials
  • Discounts

Company

  • About Us
  • Blog
  • Careers
  • Legal
  • Press
  • Privacy Policy
  • EULA

© 2022 3T Software Labs GmbH. All rights reserved.

  • Privacy Policy
  • Cookie settings
  • Impressum
When you click "Accept", you are agreeing to cookies being on your device. They may improve site navigation, site usage analysis, or the relevance of messages. It is up to you which cookies are enabled. Read our Privacy Policy.
Manage cookies
Accept
✕

Privacy Preference Center

A cookie is a small file of letters and numbers that is downloaded on to your computer when you visit a website. Cookies are used by many websites and can do a number of things, eg remembering your preferences, recording what you have put in your shopping basket, and counting the number of people looking at a website. In the form below you can choose which cookies, except for essential cookies, to allow or disable.

Accept all cookies

Manage consent preferences

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.

Accept selected