Rails/ActiveRecord sort by particular value

Question

Is there any convenient way in Rails 3.2 to order an ActiveRecord relation by moving records with a particular value for a particular field to the front of the relation? For instance, if MyModel has an attribute country, I would like to sort relations returned by any query with records having country='Spain' to the front of the relation.

Philip Hallstrom · Accepted Answer · 2013-06-12 19:05:30Z

4

Something like this. Obviously 'name, id' would depend on your model and requirements.

MyModel.order("country = 'Spain' DESC, name, id")

answered Jun 12, 2013 at 19:05

Philip Hallstrom

19.9k2 gold badges44 silver badges47 bronze badges

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

1 Comment

Philip Hallstrom Over a year ago

@RichardStokes It should move them all to the front. Can you share some code?

Collectives™ on Stack Overflow

Rails/ActiveRecord sort by particular value

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related