SoqlX Version History

v4.6, August 20, 2023

• Requires MacOS v10.14 or later.
• Fixed bug where the type field in SOSL results was not exported to CSV.

v4.5, August 9, 2023

• Requires MacOS v10.14 or later.
• Updated to Salesforce API v58.

v4.4, June 17, 2022

• Requires MacOS v10.14 or later.
• Improved performance of editing very large queries when syntax highlighting is on.
• Add preference setting to enable/disable the query auto-completions
• Updated to Salesforce API v55

v4.3, Nov 16, 2021

• Requires MacOS v10.14 or later.
• Fix bug where the login sheet doesn't show for some users.

v4.2, Oct 22, 2021

• Requires MacOS v10.14 or later.
• Login now uses the OAuth browser UI, for improved compatibility with SSO, 2FA etc.
• The column sizes in the query results now have much smarter default sizing.
• Updated for Salesforce.com API v53.

v4.1, Sept 5, 2021

• Requires OSX 10.14 or later.
• Bug fixes for SOQL highlighting / completions.

v4.0, Aug 18, 2021

• Requires OSX 10.14 or later.
• All new syntax highlighting and auto completions for SOQL and SOSL queries.
• Bug fixes for local sorting, handling of brackets in Apex and other minor fixes.
• Updated to Salesforce API v52.

v3.5, Mar 20, 2021

• Requires OSX 10.14 or later.
• Updated to Salesforce API v51.
• Additional SObject and Field properties added to the details window.
• Unset properties are no longer shown in the details window (you can re-enable this in preferences).
• Fixed a crash issue with executing Apex.
• Fixed a bug where the EntityParticle.ReferenceTo field wouldn't show a value in the query results.

v3.4, Dec 30, 2020

• Requires OSX 10.14 or later.
• Sort the query results by clicking on the column headers.
• Status footer shows query execution time.
• New Menu item for Query/QueryAll/QueryMore added with hotkey bindings.
• New Menu item to reload all the SObject metadata.
• Metadata loading progress shows in Status footer.
• Native support for Apple Silicon.
• Updated to Salesforce API v50.0.
• Fixed a bug where duplicate columns could be displayed in the query results.
• Fixed a bug where using a soqlx:// url to open the app could result in 2 windows being opened.

v3.3, Dec 1, 2019

• Requires OSX 10.13 or later.
• Added preference for number of recent queries to keep.
• Fixed bug with query results being malformed when containing related data with a mix of null and non-null values.
• Fixed bug where failed API calls would be retried forever.
• App is now notarized, should run fine on OSX 10.15.
• Updated to Salesforce API v47.0.

v3.2, Aug 20, 2019

• Requires OSX 10.13 or later.
• Updated to Salesforce API v46.0.

v3.1, Jan 21, 2019

• Requires OSX 10.13 or later.
• Updated to Salesforce API v45.0.
• Save/Load queries & anonymous apex to files.
• Preference to set query/apex text font & size.
• New soqlx:// url scheme, to allow with integration with other apps (eg. salesforce-dx).

v3.0, Nov 25, 2018

• Requires OSX 10.13 or later.
• Updated to Salesforce API v44.0
• Support for OSX Mojave Dark Mode
• Sytax highlighting, line numbers and error highlighting for apex code
• Fix for bug related to font size selection from apex tab

v2.9, Mar 7, 2018

• Updated to Salesforce API v42.0
• Fixed Typo in create Keychain entry dialog (thanks Avindra Goolcharan for the patch)

v2.8, Dec 10, 2017

• Updated to Salesforce API v41.0

v2.7, Jun 4, 2017

• Updated to Salesforce API v40.0

v2.6, Oct 16, 2016

• Updated to Salesforce API v38.0
• Add new properties to detail windows for SObjects and Fields

v2.5, July 10, 2016

• Updated to Salesforce API v37.0
• Fix crash with multiple windows open/closed
• Add new properties to detail windows for SObjects and Fields
• Fix bug where background colors get pasted into the query text

v2.4, Feb 17, 2016

• Updated to Salesforce API v36.0
• Improvements to the performance of the query coloring for large queries
• Login requests are automatically migrated from www.salesforce.com to login.salesforce (to handle a Salesforce.com deprecation)

v2.3.1, Aug 10, 2015

• Default off the 'smart' substitutions in text entry that get auto enabled by moving to the 10.9 SDK.

v2.3, Aug 9, 2015

• Requires OS 10.9 or greater
• Updated to Salesforce API v34.0
• You can now copy values out of the query result cells, even if they're not editable. (Issue #43)
• Delete record was removed from the context menu, just use the Deleted Checked button, makes it harder to accidentally delete records (Issue #42)
• The App will now exit when you close the last explorer window (If you want the old behavior, its an option in preferences) (Issue #41)
• Saving Query result to csv when the query contains a child query now includes a [## Child row] marker value instead of silently failing (Issue #36)
• SObject field names are now pre-fetcted so that search works more consistently (Issue #35)
• You can now copy the Schema Report directly to the clipboard via a new button at the bottom of the window (Issue #34)
• A bug where the first schema report saved as a PDF would have weird formatting issues was fixed (Issue #33)
• The table formatting in the Schema Report was cleaned up.
• You can now select the details window and goto Edit/Copy to copy the details table entries.
• If your API security token is needed to login and you didn't specify it, you'll now get prompted for it, rather than just seeing the error (Issue #32)
• Thanks to everyone who logged feature requests & bugs. Got an idea or seen a bug, report it in the issue tracker.

v2.2, Oct 12, 2014

• Updated to Salesforce API v32.0
• Fixed schema drawing problems on OSX 10.9 and up.

v2.1, July 6, 2014

• Updated to Salesforce API v31.0
• Added option to sort fields by name in sidebar.
• Added option to double click field name in sidebar to add/remove from query text.
• Added keyboard shortcuts for Query ⌘R / All ⇧⌘R / More ⌘M
• Added ability to change font size for query & apex text areas.
• Fixed a bug that can cause the login window to not show in some circumstances.

v2.00, Feb 18, 2014

• Updated to Salesforce API v30.0
• Added option to sort fields by name in auto generated queries.
• Added support for showing the members of the new compound field types in the query results (e.g. location & address)
• Added option to control which fields are added to auto generated queries for compound fields
• Object icons now appear in various places, including the schema views, and the object list.

v1.94, Oct 30, 2013

• Updated to Salesforce API v29.0.
• Shows organizational API usage count in bottom right of footer.
• Signed with a developerId to keep gatekeeper happy.

v1.93, Jun 27, 2013

• Requires OSX 10.7 or later.
• Updated to Salesforce API v28.0 (aka Summer '13)

v1.92, Feb 5, 2013

• Requires OSX 10.7 or later.
• Update for Salesforce API v27.0 (aka Spring '13)
• Fixed crash where "Check for updates" with no window open would cause a crash.

v1.91, Dec 22, 2012

• Requires OSX 10.7 or later.
• Fixed issue with login server names missing for clean installs.
• Reverted details/recents panel windows to previous style where they are not attached to the main window to stop them getting hidden under the main window.

v1.9, Oct 16, 2012

• Requires OSX 10.7 or later.
• Fixed crash when doing SOQL-R queries on a 64bit machine.
• Fixed bug with version fallback not working.
• Fixed layout issue with schema report window when its resized.

v1.8, Oct 8, 2012

• Requires OSX 10.7 or later.
• Multiple login/window support, just goto File->Login and have as many windows/logins open at once as you'd like.
• Can now run searches as well as queries, just type your sosl search into the query box just like you would a soql query.
• Updated to newer version of Sparkle, future updates will be cryptographically verified by the updater.
• Updated to API v26.
• Make less API calls on the main thread, less beachballs.

v1.7, June 4, 2012

• requires OSX 10.6 or later.
• Updated to API v25 (aka Summer '12).
• recents and details window now can be closed via escape key.
• Username and instance shows in the window title.
• Fixed a number of memory leaks.
• Now open source, fork me on github.

v1.6, Feb 21, 2012

• Updated to API v24 (aka Spring '12)

v1.5, Oct 8, 2011

• Updated to API v23 (aka Winter '12)
• Apex debug log settings are now remembered between runs

v1.4, Aug 11, 2011

• Fixed a bug where the apex window was using API v20 instead of API v22.
• Fixed a bug where the recent and details window would show as 'ghosts' in exposé if they were not shown.
• Thanks to @qbnrox for the bug reports.

v1.3, July 26, 2011

• Updated for API v22.0.
• Fix for an intermittent crash when the query results are being rendered.

v1.2, Feb 7, 2011

• Updated for API v21.0 (aka Spring'11)

v1.1, Oct 18, 2010

• New Apex tab allows for running of anonymous apex.

V1.00, Oct 4, 2010

• Updated to API v20.0.

v0.99, July 26, 2010

• Updated to API v19.0.

v0.98, Feb 5, 2010

• Updated to API v18.0 (if your salesforce.com instance hasn't yet been upgraded to v18, it will gracefully fallback to v17).
• The order of fields in the results table now more closely matches the order of fields in your query.
• Fixed a bug that would prevent v18 aggregate query results from displaying properly.

v0.97, Jan 8, 2010

• Updated to API v17.0

v0.96, March 30, 2009

• Object/Field filtering, enter a partial object or field name, and watch the object list shrink, and the matching fields get highlighted.
• Schema Relationship details are now shown on the details panel, and in the schema reports.
• The Schema view now shows foreign key fields, so there's more useful info on objects that are related to the selected object.
• UI Cleanup, buttons moved to button bar, new button to toggle the recent query list.

v0.95, Feb 22, 2009

• Updated to API v15.0
• Single row and bulk delete rows from a query result.
• Open records in the browser.
• Count() queries now correctly show the result.

v0.94 Oct 12, 2008

• Updated to API v14.0.

v0.93 July 24, 2008

• Updated CSV saving to remove some spacing to make the files more Excel friendly.

v0.92 July 9, 2008

• Updated to API v13.0, now includes additional CJO properties on field.
• Can now save the current query results to a CSV file. (for large result sets you get the option of the currently loaded rows, or all rows)

v0.90 Feb 3, 2008

• Now Requires Leopard.
• Support for child aggregates in SOQL-R queries, via the 2nd lower query results pane.
• Recent Queries List window shows last 10 executed queries, click on one of them to copy the query to the SOQL box.
• SObject list view moved to left and uses the standard SourceList UI style to better match the Leopard UI style, and other UI tweaks.
• Can now right click in query results to open the selected Id in the browser.

v0.84 June 25, 2007

• Minor update to fix compatibility issues with PowerPC Macs running 10.4.x and Intel Macs running the WWDC leopard beta.

v0.83 April 19, 2007

• You can now edit data inline in the query results, simply double click the cell and update its contents, and it'll update that row in Salesforce.com

v0.82 March 28, 2007

• double clicking on a cell will let you copy its value.

v0.81 Feb 18, 2007

• Reworked login to manage multiple keychain entries per server (ala Trapdoor)
• Added support for the QueryAll call.

v0.80 Jan 21, 2007

• Can now get a schema report (combination of the graphical view + a tabular report of fields and their properties) by right clicking on an SObject in the righthand list.
• Schema report can be printed out, or saved directly to a PDF file.
• Details drawer has been replaced by a new details window, and has been updated with the new object and field properties for API 8.0.
• Moved to API v8.0.

v0.71 Nov 19, 2006

• Schema explorer pane will now auto turn into a scroll view with big schemas
• Schema explorer pane will now layout all items so none overlap.
• Improved performance of schema drawing, and fixed memory leak, and overzealous window redrawing.

v0.70 Nov 17, 2006

• Brand new iLife style UI, not so much wasted space.
• Graphical schema explorer, wander around a graphical representation of your schema.
• Print support for the schema explorer (includes saving as PDF).

v0.63 Oct 30, 2006

• Added keychain support for managing your login credentials.
• Added a splitter view to the UI.

v0.62 Oct 16, 2006

• Supports connections to Sandbox edition, as well as any number of additional servers (add new servers via the preferences)
• Will now automatically check for updates and give you the option to update. (Thanks to Sparkle)
• You can open your current Salesforce session in a browser (from the menu)

v0.6 Sept 26, 2006

• Syntax highlighting and field / object validation added, invalid field or object names will appear with a dotted red line under them as you edit the query.
• Fixed a couple of UI layout problems (the progress bar would appear in the wrong place if you resized the window).
• Added a progress spinner during login so you can tell you actually clicked the login button.

v0.5 Sept 4, 2006

• First release, do object and field exploring, edit/run queries and displays the results.