|GSAK (Geocaching Swiss Army Knife)|
SqlSort OrderBy=<order by clause>
This command will allow you to change the sort order of the grid. Any valid SQLite "order by" clause for the caches table can by used to order the grid. Not only can you sort ascending/descending by multiple columns but you can use functions as well. For example to sort the grid in sequence of the longest hint first to the smallest hint the code would simply be:
To sort by ascending by difficulty then descending by distance the code would be:
Using the $_OrderBy system variable, also makes it quite easy to save and restore your current grid sort sequence
Note: SQLSort is just a portal to the SQLite "Order by" clause and is not aware of any GSAK settings. What ever you "Order by" here is used verbatim and not affected by any GSAK settings (like special sort sequence for "name").
Alpha List Category List
Copyright 2004-2015 CWE Computer Services |