A new maintenance release of SOQL Studio is now available for download. Version 2020.1.282 includes several enhancements and minor bug fixes. In this post I’ll provide a complete list of the changes as a well as go into detail on some of the more significant changes.
- Upgraded to API v48 (Spring ’20 release)
- Improved handling of Date data types on Export. Date data will no longer include a time portion. Date and DateTime values are rendered using culture-specific format in Pretty and Windows mode and Salesforce format in None mode
- Improved rendering and scrolling performance when child queries contain a large number of rows
- Improved rendering of the row number column so that the chevron to expand/collapse a row’s child query results doesn’t overlay all or part of the row number
- Upgraded to target .Net Framework v4.7.2 to take advantage of new functionality, improved performance and better TLS support now and in the future. Note: Additional configuration may be required on Windows 7 to enable TLS 1.2 support. See this post on our blog for more information and guidance.
- Corrected an issue that caused queries to fail with a Null Reference Exception error when a child query returned more than 2000 rows
Exporting Date Data
In prior releases of SOQL Studio, columns with a data type of Date as opposed to DateTime were exported as DateTime values with the time portion valued as 12 midnight (00:00:00.000). This release changes that. Only the date portion will be exported. In addition, both Date and DateTime data will now be exported using culture-specific formatting. These changes only impact exports done in ‘Windows’ and ‘Pretty’ mode. Exports done in ‘None’ mode always export the data exactly as it was sent by Salesforce.
We’ve made changes to the way child query results are rendered that significantly improves UI performance when there is more than 50 rows of child data. In prior releases, the grid of child query results was rendered in its entirety. We’ve updated this behavior so that subordinate grids only show about 10 rows at a time along with a vertical scrollbar so that you can scroll through additional rows.
.Net Framework Update
We’ve update SOQL Studio to target .Net Framework v4.7.2 to take advantage of it’s increased performance and capabilities. This allowed us to remove some add-on assemblies and their licensing agreements from the installer as well as positioned SOQL Studio to fully support future TLS requirements. The move to .Net 4.7.2 may impact Windows 7 users, however, because the version of TLS the Framework selects is determined differently in 4.7 vs. 4.6. Review our blog post on the issue and how to update your configuration to mitigate it.
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 2020.1 and you can download the new package right from there.