Mongoid Rails 4 sort by asc or desc order created_at

Question

I have a rails 4 app using Mongoid. I want to do something basic is display the book model I have by descending order according to the field created_at in the index view. In the controller books_controller.rb:

def index
  @books = Book.order_by(:created_at.desc)
end

This is not working. I also tried the following 2 that are not working:

@books = Book.find :all, :order => "created_at DESC"

Book.find(:all, :order => "created_at DESC").each do |item|
  @books << item
end

In the view i have something like this:

<% @books.each do |b| %>
  ...
<% end %>

Thank you.

What do you mean it didn't work? Did you got any error? – Pavan Jun 04 '14 at 12:06 — Pavan, Jun 04 '14 at 12:06

score 66 · Accepted Answer · edited Aug 08 '18 at 17:22

66

You can try this

def index
  @books = Book.order_by(created_at: :desc)
end

it works fine.

edited Aug 08 '18 at 17:22

Lee Dykes

1,017
8
16

answered Jun 04 '14 at 18:35

Shahzad Tariq

2,767
1
22
31

7

Minor improvement: `@books = Book.order_by(created_at: :desc)` – newUserNameHere Mar 10 '16 at 19:18

score 4 · Answer 2 · answered May 31 '16 at 09:57

4

def index
   @books = Book.order(:created_at => 'desc')
end

It works for me, instead of order_by use order(depends on rails version)

answered May 31 '16 at 09:57

pbms

586
1
10
32

score 3 · Answer 3 · answered Jul 08 '16 at 09:04

You can use both "order" and "order_by", and they are equivalent. All these are equivalent:

Book.order_by(created_at: :desc)
Book.order_by(created_at: -1)
Book.order(created_at: :desc)
Book.order(created_at: -1)

This is the source code from mongoid 5.1.3 "lib/mongoid/criteria/queryable/optional.rb":

# Adds sorting criterion to the options.
#
# @example Add sorting options via a hash with integer directions.
#   optional.order_by(name: 1, dob: -1)
#
# @example Add sorting options via a hash with symbol directions.
#   optional.order_by(name: :asc, dob: :desc)
#
# @example Add sorting options via a hash with string directions.
#   optional.order_by(name: "asc", dob: "desc")
#
# @example Add sorting options via an array with integer directions.
#   optional.order_by([[ name, 1 ], [ dob, -1 ]])
#
# @example Add sorting options via an array with symbol directions.
#   optional.order_by([[ name, :asc ], [ dob, :desc ]])
#
# @example Add sorting options via an array with string directions.
#   optional.order_by([[ name, "asc" ], [ dob, "desc" ]])
#
# @example Add sorting options with keys.
#   optional.order_by(:name.asc, :dob.desc)
#
# @example Add sorting options via a string.
#   optional.order_by("name ASC, dob DESC")
#
# @param [ Array, Hash, String ] spec The sorting specification.
#
# @return [ Optional ] The cloned optional.
#
# @since 1.0.0
def order_by(*spec)
  option(spec) do |options, query|
    spec.compact.each do |criterion|
      criterion.__sort_option__.each_pair do |field, direction|
        add_sort_option(options, field, direction)
      end
      query.pipeline.push("$sort" => options[:sort]) if aggregating?
    end
  end
end
alias :order :order_by

Vinu Joseph · Answer 4 · 2017-09-26T09:41:30.130

3

Book.where(author: "Stephen King").sort({"created_at": 1})--> Ascending Order

Book.where(author: "Stephen King").sort({"created_at": -1}) --> Descending Order

edited Sep 26 '17 at 09:41

answered Sep 13 '17 at 08:45

Vinu Joseph

965
9
11

Wrong syntax, plus `sort` doesn't appear to be an existing method. – Bad Request Sep 20 '17 at 15:59
Edited the syntax error. Sort option is available while using mongoid gem. Try it out now. – Vinu Joseph Sep 21 '17 at 07:04
1

Thanks for the edit. `Book.sort({"created_at": 1})` is still invalid for me, but `Book.where(author: "Stephen King").sort({"created_at": 1})` is valid. – Bad Request Sep 22 '17 at 21:15

score 1 · Answer 5 · answered Sep 16 '20 at 03:40

1

def index
  @books = Book.desc(:created_at)
end

It works fine.

answered Sep 16 '20 at 03:40

Shekhar Patil

337
4
14

Mongoid Rails 4 sort by asc or desc order created_at

5 Answers5