Rails 3 - ActiveRecord and reverse sort

Question

I have following data in database:

And I would like to get to output this:

3
4
5

I need it to print in the view:

<%car.colors.limit(3).order('created_at ASC').each do |color|%>
  ...

I know that exists reverse_order, but exist something like reverse sort?

(I know that is possible to load the data into an array and then go through the array, but this way is not very efficient)

Chowlett · Accepted Answer · 2012-02-13 17:35:32Z

22

How about just doing

<%car.colors.limit(3).order('created_at DESC').reverse.each do |color|%>

answered Feb 13, 2012 at 17:35

Chowlett

47k21 gold badges119 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Chowlett Over a year ago

Would the anonymous downvoter like to tell me what I've got wrong?

Matt Scilipoti Over a year ago

This method reverses the data after it has been retrieve from the database. The answer from JellicleCat uses the database to sort it.

Chowlett Over a year ago

@MattScilipoti - but it gives the wrong answer. The OP wants (the first three in descending order), printed in ascending order. You'll note that I also use the database to perform the descending order, but I can't see how to use the DB to get it back into ascending order for display.

Alex Antonov · Accepted Answer · 2015-06-03 19:06:44Z

21

For Rails 4:

[Model].order(column: :desc)

For Rails 3:

[Model].order("<column> DESC")

For Rails 2:

[Model].all(:order => "<column> DESC")

edited Jun 3, 2015 at 19:06

Alex Antonov

15.4k10 gold badges75 silver badges157 bronze badges

answered May 21, 2012 at 21:17

Jellicle

30.6k25 gold badges119 silver badges179 bronze badges

Comments

Kaleem Ullah · Accepted Answer · 2015-09-18 08:47:40Z

0

One line Solution

in your controller use:

class Api::ImagesController < ApplicationController

  def index
    @posts =  Post.all.paginate(:page => params[:page], :per_page => 4).order(id: :desc)
    render :json => @posts.to_json(:methods => [:image_url])
  end

end

edited Sep 18, 2015 at 8:47

answered Sep 17, 2015 at 14:12

Kaleem Ullah

7,1293 gold badges45 silver badges48 bronze badges

Collectives™ on Stack Overflow

Rails 3 - ActiveRecord and reverse sort

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related