A major new release of SOQL Studio, version 2019.1, is now available. This release continues our commitment to providing regular enhancements and fixes to SOQL Studio and staying current with Salesforce releases. It also sets the stage for some more significant features to come in the future.
- Added the ability to change the order that Organizations are displayed in the Organizations Tool Window and all selection lists
- Continued building out the grouping of Sobjects within the Organizations tool window
- Added the optional ability to display Sobject and Field labels in the Organizations tool window
- Enhanced the Organizations tool window’s context menu to be more dynamic and only present menu choices that are appropriate for the selected Sobject
- Implemented the ability to send just the selected text in a SOQL editor to Salesforce for execution
- Introduced support for the use of a semicolon as a query terminator
- Upgraded to API v45 (Spring ’19)
- Fixed an issue that caused a constraint violation when querying an Sobject where the ID field is not unique and the ID field was included in the Select statement
- Fixed an issue introduced in the last build that prevented the context menu from being displayed in the results grid
- Renaming an Org now gets properly reflected everywhere it is referenced
- Fixed an issue with the display of an Org’s contents when refreshing it in the Organizations tool window
Several of the enhancements in this release including the display of labels in the Organizations tool window and the Execute Selection functionality are the direct result of requests from you, our customers, so keep them coming! Now, let’s dive into some detail about the various enhancements in this release:
The Organizations Tool Window
Much of the work in this release is visible in the Organizations tool window. We continued to refine the grouping of objects into folders so that the ones that contain an org’s primary user data aren’t mixed in with other objects that you probably aren’t too interested in.
Figure 1 shows the revised groupings. You’ll notice that we’ve removed the ‘Support Objects’ group and added two new groups ‘Namespaced Objects’ and ‘Other Objects’. Let’s get into each of the groups and what they contain. Standard Objects contains all the primary data objects like Account, Contact, and Opportunity that come standard with a Salesforce org while Custom Objects contains customer created objects that are in the default namespace. The Namespaced Objects folder contains objects that are in namespaces other than the default namespace. Each namespace gets its own folder with its objects contained within. Here is where you’ll find the objects from managed packages, for example. The Other Objects folder organizes the rest of the org’s objects into the categories of Programmability, Histories, Sharing, Feeds, Tags, and Non-Queryable Objects. The groupings are dynamic meaning that if an org doesn’t have any content for a particular folder that folder will not be presented. Bottom line, you’ll never see an empty folder in the Organizations tool window.
Another usability enhancement is the display of labels in addition to the API name of an object or field. Figure 1 shows the Organizations tool window with this feature turned on. Object and field labels appear in parenthesis next to the API name.
Both the Grouping and Labels features are optional and can be enabled on the General tab of the Options dialog.
We also made improvements in the context menu that pops up when you right-click on an object. Prior to this release, SOQL Studio would always present the ‘Generate/Execute Browse Query’ choice even when the object wasn’t queryable. With this release, that choice will only be available when the object is queryable.
The SOQL Editor
This release of SOQL Studio includes two new features in the SOQL Editor that SQL programmers are already familiar with: the ability to send the currently selected text in the editor to the server for processing and the use of a semicolon as a query terminator.
The ability to select a SOQL query from several in the same document and run it gives SOQL Studio users another productivity boost. Just from a developer’s perspective, you can have a single SOQL Editor open that contains a bunch of SOQL, perhaps from an apex class you’re writing, and you can just highlight the one you want and run it. You can run it from the editor’s context menu or from the ribbon’s Execute dropdown button.
If you spend a lot of time switching back and forth between SOQL and SQL, you may find yourself always adding the terminating semicolon to your queries. While that’s fine in the SQL world, Salesforce does not recognize it and will generate an error. SOQL Studio has been enhanced to support the use of a terminating semicolon. Like comments, it will be removed from the SOQL before it gets sent to Salesforce.
The ability to reorder the list of organizations is another item that we’ve had on our To Do list since we first started developing SOQL Studio. Prior to this release, all orgs where listed in the order that they were defined. Now you’ll be able to order them any way you’d like in the Managing Organizations tool. The order you define there is instantly reflected everywhere else orgs are presented in a list: the Organizations tool window and the various org selection dropdown lists.
Just select the org you want to move and click the up or down arrow button to change its position.
Learn more about SOQL Studio by visiting our website. If you’ve never tried SOQL Studio, or tried an older version, we encourage you to start a 30-day free trial of SOQL Studio 2019.1 today! 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.