Sort the array returned by ActiveRecord by date (or any other column)

Question

How can I sort the array returned by an ActiveRecord request by the created_at date column?

This happens after the request is completed.

Please do not tell me to do this in the request, because I need this to happen in the view.

Answer 1

Ruby includes support for sorting out of the box.

 sorted = @records.sort_by &:created_at 

However, this does not seem to have much to do with the mapping, and probably belongs to the controller.

Answer 2

While Ruby Enumerable is awesome, ActiveRecord queries will actually return ActiveRecord :: Relation, whose query has not yet been evaluated (Lazy Loading), and may have an ordering method that calls it to disable this processing in the database, where it will scale much better than enumerable strategy.

Using Enumerable for sorting also mixes pagination into the database. There is nothing to prevent the application of an ordering strategy in a view. However, I would try to include this in the model for model.

 sorted = @records.order(:created_at) 

Answer 3

Just call sorting in the collection, passing to the block of code that tells Ruby how you want to sort it:

 collection.sort { |a,b| a.created_at <=> b.created_at } 

Answer 4

Please lure him and also check the difficulty.

 Model.all.sort_by{|m| m.created_at} #=> O(log n) #versus Model.order("created_at DESC") #=> O(1) 

Answer 5

The best way to sort an ActiveRecord array is to use the default method method

@ users.order (: created_at)

This is the fastest and most correct solution, because in this case it returns a sorted array from db, and you do not need to use any other operation for this in the class, for example, if you use the proposed sort_by , it will loop every element array, and after that it will not be an ActiveRecord array, not cool in my opinion.

order can use strings and sumbols, it is very useful, and several parameters are required

@ users.order ('created_at asc, first_name desc, last_name asc')