GSAK (Geocaching Swiss Army Knife)
 

Contents - Index


Sort (command)

SORT <by="column(s)"> [<sequence=A|D>] 

This macro command will allow you to run your own sort sequences for the GSAK data. Clicking on the column heading just isn't good enough - column heading sorts do not allow sub sorting (You could then assign to macro buttons if you use them often).

By = The column(s) to sort on. Separate more than one column with a ; (semi colon). For example if you wanted your data Sorted firstly by cache type, then bearing, then distance, the command would be:
SORT by="CacheType;Bearing;Distance" 

Note: use the reserved column "natural" to sort the waypoints in natural sequence (in the order the waypoints were added to the database)

Supported and valid column names are:

archived - The archived status
bearing - The bearing from the current centre point
cachetype - The cache type
changed  - Changed date
code - The waypoint code
container  - The container
country - Country the waypoint is located
created - Date the waypoint was created in the database
name - The waypoint name ("description" is also supported for backwards compatibility)
difficulty - Difficulty rating
distance - Distance from the current centre point
dnf - DNF status
dnfdate - DNF date
found - Found status
FoundbyMe - Date "found by me"
FoundCount - Total found (by you) count for each cache
FoundDate - Date last found
FTF - First to find
HasBug - Travel bug status
lastlog - Date of the last log (any)
lastupdate - Date the waypoint was last updated by a GPX/LOC file
lastuser - Date waypoint was last updated manually by the user
lock - Lock status
MacroSort - Special "Macro Sort" column
natural - Natural order (order the waypoints were added to the database)
numberoflogs - number of logs for each waypoint
ownerid - owner id
placedby - Placed by
placeddate - Date placed
smartname - GSAK smart name
source - GPX/LOC data source
state - State the waypoint is located
terrain - Terrain rating
userdata - User data
user2 - User data 2
usersort - user sort field
watch - Watch status


Sequence = The sorting sequence. A = Ascending, D = Descending, the default being A

Warning: When using natural or more than one column to sort in (that is, if your by parameter contains a semi colon) any subsequent updates to the database will require another macro SORT command to correctly sort all the records in the database. Another words, when sorting multiple columns this command is only good for the current snapshot of records 
Summary

Copyright 2004-2008 CWE Computer Services  
Privacy Policy Contact