We are extremely pleased to announce that SOQL Studio 2021.2 is now generally available for download on our site. Building upon the success of version 2021.1 released in May, version 2021.2 focuses on new functionality centered around the Organizations tool window. As with all of our releases, this one continues our commitment to providing regular enhancements and fixes to SOQL Studio, many of which were customer suggestions, and staying current with Salesforce releases
In this post, I’ll discuss some of the larger items included in the release, but first here’s the complete list of the enhancements and fixes included:
- Added filtering capabilities to the Organizations tool window. When active, the filtering function hides items that don’t contain the filtering term, leaving only the items that match and their parents. The filter matches on the API Name and Label attributes
- Added the ability to drill down into relationship fields in the Organizations tool window and see the underlying object’s fields. Commonly referred to as viewing child objects, the drill down functionality also provides for dragging child object fields into the SOQL Editor with the field’s complete relationship path prepended
- Updated the Organization load logic so that all Sobjects (except Tooling API objects) in an Organization are now loaded when the Org first connects to Salesforce. This enables filtering and drill-down, and speeds up other operations that may have had to perform Sobject loads on-demand
- Added the ability to list standard fields before custom fields in the Organizations tool window. Disabled by default, enable this optional feature on the General tab of the Options dialog
- Standard and Custom fields now use slightly different icons in the Organizations tool window, providing a quick visual queue that differentiates between the two types
- Added ‘CTRL+F5’ as a keyboard shortcut for the ‘Execute Selection’ command
- Enabled the use of ‘//’ as a single line comment delimiter in addition to ‘
- Added the ability to configure the Comment and Uncomment buttons to use ‘//’ as the single line comment delimiter rather than the default ‘
- Added the ability to copy the record count from the SOQL editor’s status bar
- Upgraded API support to Summer ‘21 (API v52)
- Fixed an issue introduced in v2021.1 that in rare instances could cause the app to crash during startup
- Fixed an issue where opening a file from the command line put an extra space after the file extension causing ‘Save as’ to not recognized the file has an extension
Schema Filtering, Related Object Drill-Down & Loading an Organization’s Schema
The ability to filter an organization’s schema and drill down into relationship fields have long been on our list of future enhancements. This was a large effort because of the underlying changes we needed to make to the way SOQL Studio loads an Organization.
Prior to this release, when SOQL Studio first connected to Salesforce to load an organization, it would only get the list of Sobjects and some skeletal properties about each object. An Sobject’s full properties, list of fields and their related properties wouldn’t get loaded until the object was expanded or a query was run that referenced that object. It was an effective load strategy that worked extremely well until we started to consider filtering and child object drill down. To do those two things properly, SOQL Studio needed to load the entire org schema on the first connection to Salesforce. The only exception to this is the Tooling API schema, which doesn’t get pre-loaded. Loading in this manner does take a longer to complete, but SOQL Studio doesn’t block the UI while the load is in progress so you can continue to work, even in the schema.
The image above shows the updated Organizations tool window with the filtering controls visible and drill down into the LastModifiedById field of the custom object.
This version includes several small, customer requested tweaks that I’d like to highlight. The first is the addition of ‘//’ as a line comment delimiter. Apex developers will really like this because now they’ll be able to copy SOQL from an Apex class and not have to replace Apex line comment delimiters with the SOQL Studio line comment delimiter. The new delimiter does not replace the existing one, it’s in addition to it and you can use both in the same SOQL editor. We also added the ability to configure which delimiter the Comment and Uncomment buttons use, so if you prefer to use ‘//’ as your default, you can do that.
Another small tweak was the addition of a keyboard shortcut for the Execute Selection command. This was another customer request that we were happy to accommodate. Now you can use CTRL+F5 to execute the selected SOQL in the active editor.
Finally, we made some visual updates to the schema that I hope you find useful. The icon used in the Organization schema used to be the same for all fields. We changed that so that standard fields and custom fields have slightly different icons. Standard fields continue to use the icon from prior releases. Custom fields, however, use a modified version. The coloring and highlighting are subtly different, but enough to be a quick visual queue to distinguish between the two types. The image above illustrates this.
In addition, you can configure the Organization tool window to display an sobject’s standard fields first followed by its custom fields. Fields would still appear alphabetically within each category. This feature is turned off by default.
Current customers with an active maintenance contract are entitled to a free upgrade. Login to you account, go to Downloads & Licenses and click the “Request Upgrade” button. You’ll be emailed a new license for version 2021.2 and you can download the new package right from there.