Rails: Order with nulls last

by

I’m no expert at SQL, but why not just sort by if something is null first then sort by how you wanted to sort it.

Photo.order('collection_id IS NULL, collection_id DESC')  # Null's last
Photo.order('collection_id IS NOT NULL, collection_id DESC') # Null's first

If you are only using PostgreSQL, you can also do this

Photo.order('collection_id DESC NULLS LAST')  #Null's Last
Photo.order('collection_id DESC NULLS FIRST') #Null's First

If you want something universal (like you’re using the same query across several databases, you can use (courtesy of @philT)

Photo.order('CASE WHEN collection_id IS NULL THEN 1 ELSE 0 END, collection_id')

More Related Contents:

  1. Eager load polymorphic
  2. Rails order by results count of has_many association
  3. How to chain scope queries with OR instead of AND?
  4. When to use a “has_many :through” relation in Rails?
  5. Rails 3: Get Random Record
  6. Setting session timeout in Rails 3
  7. Alias for column names in Rails
  8. ActiveRecord Find By Year, Day or Month on a Date field
  9. Rails 3 devise, current_user is not accessible in a Model ?
  10. Rails 3, has_one / has_many with lambda condition
  11. Rails 3 – select with Include?
  12. belongs_to through associations
  13. Check if record exists from controller in Rails
  14. Validate uniqueness of multiple columns
  15. Rails – Validate Presence Of Association?
  16. How to implement bulk insert in Rails 3
  17. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  18. Specifying column name in a “references” migration
  19. Why do routes with a dot in a parameter fail to match?
  20. Rails 5: ActiveRecord OR query
  21. Ruby on Rails. How do I use the Active Record .build method in a :belongs to relationship?
  22. rake db:schema:load vs. migrations
  23. How does Rails ActiveRecord chain “where” clauses without multiple queries?
  24. What is the replacement for ActionController::Base.relative_url_root?
  25. How to test for (ActiveRecord) object equality
  26. Bulk Insert records into Active Record table
  27. Delete link sends “Get” instead of “Delete” in Rails 3 view
  28. Rails 3.1 limit user created objects
  29. Is there a way to avoid automatically updating Rails timestamp fields?
  30. How to set default rails version for a project?

Leave a Comment