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
    • AI Helper
    • Team Sharing
    • Index Manager
    • More Tools and Features
  • Solutions
  • Resources
    • Knowledge Base
    • MongoDB Tutorials & Courses
    • Tool/Feature Documentation
    • Blog
    • Community
    • Testimonials
    • Whitepapers
    • Reports
  • Contact us
    • Contact
    • Sales Support
    • Feedback and Support
    • Careers
    • About Us
  • Store
    • Buy Now
    • Preferred Resellers
    • Team Pricing
  • Download
  • My 3T
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 2023.4 – The New Index Manager, Collection History & More
  • What’s New in Studio 3T 2020.10 | Data Masking, Reschema & The Fastest Studio 3T Version Yet
  • What’s new in Studio 3T 2022.9 – Time Series and default Mongosh
  • What’s New in Studio 3T 2021.8 | Custom Column Orders, new edition names, and more
  • Time Series Collections in Studio 3T

Tags

2022 academy aggregation AMA atlas Certification christmas community connections culture date tags events export features hackolade import intellishell In Use JSON knowledge base migration modelling mongodb mongoodb mongosh My 3T productivity product management query regex releases schema security SQL Studio 3T studio3t tasks time series 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
  • White Papers
  • Testimonials
  • Discounts

Company

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

© 2023 3T Software Labs Ltd. All rights reserved.

  • Privacy Policy
  • Cookie settings
  • Impressum

We value your privacy

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.

By clicking “Accept all”, you consent to the storage of cookies and the processing of personal data for these purposes, including any transfers to third countries. By clicking on “Decline all”, you do not give your consent and we will only store cookies that are necessary for our website. You can customize the cookies we store on your device or change your selection at any time - thus also revoking your consent with effect for the future - under “Manage Cookies”, or “Cookie Settings” at the bottom of the page. You can find further information in our Privacy Policy.
Accept all
Decline all
Manage cookies
✕

Privacy Preference Center

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.

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.

Google Analytics

Google Ads

Bing Ads

Facebook

LinkedIn

Quora

Hotjar

Reddit

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.

HubSpot

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
✕