Server based results sorting

Posted by Kyle Hankinson August 12, 2020

---

Overview

Server based results sorting is a helpful and quick way for users to sort all results from a table without needing to write SQL. As of SQLPro v2020.71 is has been enabled by default. Using it is easy as can be. Simply click the header of a result set. The updated sort statement appear 'ghosted' in your query.

How to disable

Server based sorting can be disabled via the 'SQLPro' -> 'Preferences' menu item. Once the preferences dialog is visible uncheck the 'Server based results sorting'.

Notes

Server based sorting only works for simple queries. If the query is complex, then the results will be sorted locally using the 'in memory results'.

---