Sort changesets by close time to match selection

This ensures that the sort can be optimised using the index
when selecting by time.

diff --git a/app/controllers/api/changesets_controller.rb b/app/controllers/api/changesets_controller.rb
index 66014042718126ceca06b3bd3f864a7bb6985be6..0a49a95f4e01e98a99c07566f6da92282448e09b 100644 (file)
--- a/app/controllers/api/changesets_controller.rb
+++ b/app/controllers/api/changesets_controller.rb
@@ -172,9 +172,9 @@ module Api
 
       # sort the changesets
       changesets = if params[:order] == "oldest"
-                     changesets.order("created_at ASC")
+                     changesets.order(:closed_at => :asc)
                    else
-                     changesets.order("created_at DESC")
+                     changesets.order(:closed_at => :desc)
                    end
 
       # limit the result