diff options
Diffstat (limited to 'rides/rides.go')
| -rw-r--r-- | rides/rides.go | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/rides/rides.go b/rides/rides.go index b0ce5fb..94fbc64 100644 --- a/rides/rides.go +++ b/rides/rides.go @@ -37,6 +37,7 @@ const ( SortStartDate SortColumn = "started" SortDistance SortColumn = "distance" SortMovingTime SortColumn = "moving_time" + SortSpeed SortColumn = "speed" SortElevation SortColumn = "elevation" SortCotacol SortColumn = "cotacol" SortCotacolKm SortColumn = "cotacol_100km" @@ -156,6 +157,7 @@ var sortExpressions = map[SortColumn]string{ SortStartDate: "start_date", SortDistance: "distance_m", SortMovingTime: "CASE WHEN moving_time_algo_version = ? THEN COALESCE(moving_time_s, external_moving_time_s) ELSE external_moving_time_s END", + SortSpeed: "average_speed_mps", SortElevation: "total_elevation_gain_m", SortCotacol: "cotacol_score", SortCotacolKm: "cotacol_score * 100000.0 / NULLIF(distance_m, 0)", |