ActiveRecord Find All not sorting by ID?

by

Ordering by ID is not guaranteed by default. It’s up to the database how a non-ordered query gets ordered (typically it’s unspecified). If you want your results to be ordered, you need to specify an explicit order with order, as you’ve done:

Model.order(id: :asc)

Note also that ordering by id should only be done if you want a deterministic order. If you want to order by time, use created_at or updated_at (nothing guarantees that ids are chronologically ordered). If you want all queries to always be ordered, you could use default_scope, but generally its use should be avoided.

More Related Contents:

  1. HABTM Polymorphic Relationship
  2. How to use ANY instead of IN in a WHERE clause?
  3. rails error, couldn’t parse YAML
  4. Share database between 2 apps in Heroku
  5. Understanding :source option of has_one/has_many through of Rails
  6. Implement “Add to favorites” in Rails 3 & 4
  7. Rails 3 ActiveRecord: Order by count on association
  8. How to chain scope queries with OR instead of AND?
  9. How to empty a Heroku database
  10. Rails 3: Get Random Record
  11. Setting session timeout in Rails 3
  12. Alias for column names in Rails
  13. Stubbing authentication in request spec
  14. Rails 3 devise, current_user is not accessible in a Model ?
  15. Rails’ link_to method: GETing when it should DELETE
  16. Rails 3.1: Engine vs. Mountable App
  17. Disable HTML escaping in erb templates
  18. Separate REST JSON API server and client? [closed]
  19. Rails 3 – select with Include?
  20. rmagick gem install “Can’t find Magick-config”
  21. belongs_to through associations
  22. Check if record exists from controller in Rails
  23. Rails Engine – Gems dependencies, how to load them into the application?
  24. Rails 3 library not loading until require
  25. Clarification on how to use “thumbs_up” voting gem with Rails 3
  26. Find all records which have a count of an association greater than zero
  27. Rails 3 render action from another controller
  28. rails 3 activerecord order – what is the proper sql injection work around?
  29. Error “…cannot load such file — mysql2/2.0/mysql2 (LoadError)”. On Windows XP with Ruby 2.0.0
  30. Setting up a polymorphic has_many :through relationship

Leave a Comment