A new maintenance release is available for SOQL Studio. The release includes several enhancements and bug fixes. In this post, we’ll explore the two more significant enhancements, but first a quick list of the release’s contents:
- Implemented optional grouping of sObjects by object type in the Organizations Tool Window. With grouping enabled, an organization’s sObjects will be grouped into folders for Standard objects, Custom objects and support objects
- Modified the Text and Excel/CSV export processes to always enclose text data in quotes when it contains CRLF
- Updated the Text export process to include CSV as a file type option in the Save Export As dialog. Text exports using a comma as a delimiter will default to the “.csv” extension while other Text exports will continue to default to “.txt”
- Added native support for custom API login domains
- Added settings to the Options dialog for the new sObject grouping and API login URL override features
- Upgraded the supported API level to Summer ’18 (API version 43)
- Corrected an issue where the default for “Include column headers” was not set properly for the Text target in the Export Wizard
The two big items in this release are the new features that let you group the display of sObjects in the Organizations tool window and the addition of native support for custom API login domains. Let’s look at each of these in more detail.
Grouping of sObjects
One of the goals of SOQL Studio was to make discovering and navigating an org’s schema easy. We think we’ve accomplished this goal, but if we see an opportunity to do more, we’re going to take it. This was the genesis for grouping. There are a lot of objects in a Salesforce org before you even get started creating your own. Scrolling through the list in the Organizations tool window can become tedious, even with its ability auto-scroll when you type a few characters of the object name. Generally you know if the object you are looking for is standard or custom and we rarely, if ever, need to look at those “support” objects. You know, __tag, __history, __feed that can be associated with every object. So we provided an option that groups them into folders in an effort to reduce clutter. With grouping enabled, Standard objects and Custom objects are separated into folders named, appropriately, Standard Objects and Custom Objects. The tag, feed, and history supporting objects are all put into the Support Objects folder. Of course, grouping is optional and is disabled by default. To enable it, go into Options and on the General tab check the new “Group sObjects in Organizations tool window” setting found in the User Interface Options section.
Custom Login Domain
Some orgs restrict the use of Salesforce’s standard login URL’s of login.salesforce.com and test.salesforce.com, even for API logins. Those orgs only allow login via their custom domain. Prior to this release, the only way SOQL Studio could connect to an org with a custom domain requirement was to manually edit the application’s config file to replace the standard login URL with the org’s custom one. That works if you only have a production org. Add in sandboxes, and you’ll find yourself editing the config file every time you want to connect to an org on a different server. That gets old real fast and significantly diminishes the tool’s power. To remedy this situation, we’ve added native support for custom login domains. To enable this feature, go to the Advanced tab of Options and check the “Enable custom API login domain” option found in the Network Connection section. Once the feature is enable, the Manage Organizations dialog will display a new section where you can enter the custom domain specification.
If you work with multiple orgs and some require a custom domain and some don’t, no worries! Use of a custom login domain is optional. Leave the “Custom API Login Domain” field blank and SOQL Studio will connect to that org using the standard login URL applicable to the Org Type.
Learn more about SOQL Studio by visiting our website. Haven’t tried SOQL Studio yet? Start your 30-day free trial today! And remember, customers with an active maintenance contract are entitled to this version free of charge.