diff options
| author | Yorick Peterse <yorickpeterse@gmail.com> | 2016-01-06 19:29:44 +0300 |
|---|---|---|
| committer | Yorick Peterse <yorickpeterse@gmail.com> | 2016-01-07 16:53:02 +0300 |
| commit | 9dacc3bc568c6c8cfc4a1bc1af23eb96f9eae9b0 (patch) | |
| tree | 9560b56e8b8cb45035c035829b9125fd0b711d3a /app/models/concerns/sortable.rb | |
| parent | 7a240397afc56ab366b6c3504761fbf531b78ec1 (diff) | |
Sort by ID when sorting using "Recently created"
Sorting by "id" has the same effect as sorting by created_at while
performing far better and without the need of an extra index (in case
one wanted to speed up sorting by "created_at").
Sorting by "Recently updated" still uses the physical "updated_at"
column as there's no way to use the "id" column for this instead.
Diffstat (limited to 'app/models/concerns/sortable.rb')
| -rw-r--r-- | app/models/concerns/sortable.rb | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/app/models/concerns/sortable.rb b/app/models/concerns/sortable.rb index 7391a77383c..8b47b9e0abd 100644 --- a/app/models/concerns/sortable.rb +++ b/app/models/concerns/sortable.rb @@ -11,6 +11,7 @@ module Sortable default_scope { order_id_desc } scope :order_id_desc, -> { reorder(id: :desc) } + scope :order_id_asc, -> { reorder(id: :asc) } scope :order_created_desc, -> { reorder(created_at: :desc) } scope :order_created_asc, -> { reorder(created_at: :asc) } scope :order_updated_desc, -> { reorder(updated_at: :desc) } @@ -28,6 +29,8 @@ module Sortable when 'updated_desc' then order_updated_desc when 'created_asc' then order_created_asc when 'created_desc' then order_created_desc + when 'id_desc' then order_id_desc + when 'id_asc' then order_id_asc else all end |