Aggregation query building gets even easier in Studio 3T 2019.4, which now comes with smart auto-completion and a handy integration with IntelliShell.

Headline feature

Auto-Completion in Aggregation Editor

IntelliShell’s convenient auto-completion feature is now available in the Aggregation Editor, Studio 3T’s stage-by-stage aggregation query builder.

While working on a stage, Studio 3T can now display intelligent suggestions such as:

  • Field names from collections (as JSON keys)
  • Field names from previous stages (as JSON keys)
  • References from collections (as JSON values)
  • References from previous stages (as JSON values)

To activate auto-completion, press Ctrl + Space (^ + Space).

View entire aggregation queries and edit in-place

In addition to the standard pipeline view in the Aggregation Editor and the mongo shell view in Query Code, you can now also view the entire aggregation query in IntelliShell, which is displayed in its own tab within the Aggregation Editor.

Simply go to Query Code and click on the IntelliShell icon to open the full query in a separate IntelliShell tab, which you can then edit in-place.

IntelliShell integration in Aggregation Editor

Paste and parse full queries into the Main Query Bar

Working a lot in between IntelliShell and the Visual Query Builder?

Now you can copy a full query from IntelliShell or Visual Query Builder and paste it directly into the Main Query Bar, which it will automatically parse, with a click of a button.

Pasting a full query into the Main Query Bar

Fixes and Improvements

  • IntelliShell – Selected text can be (un)indented by pressing (Shift+)Tab
  • Oracle SQL Connections – Internally using services-based connections for improved compatibility

…among many other fixes and improvements. Find the complete list in the changelog.

Download Studio 3T

Upgrade to the latest Studio 3T version, or start your free 30-day trial today:

  1. Reply

    Updated to version 2019.4.1 and the IntelliShell is no longer working for me. Underlying mongo version is 3.4.14.
    Previous IntelliShell was bundled with shell version v4.0.2 and now is bundled shell version v4.0.10
    When opening IntelliShell get a message “The shell process has terminated. Click here to restart” above the shell’s icons with shell output of “MongoDB shell version v4.0.10
    authentication failed, please review connection settings.”

    The collection and aggregate interfaces both seem to work correctly, so may just have to point to a different version of the underlying shell.

    1. Reply

      Hi Kevin,

      Not to worry – this is a known issue. Please reach out to us at [email protected] and we’ll be able to assist you.

      Regards,
      Paul

Leave a Comment

Your email address will not be published.

You may use these HTML tags and attributes: <a href=""> <abbr> <acronym> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>