Rails best way to get previous and next active record object

by

Write these methods in your Product model:

class Product

  def next
    self.class.where("id > ?", id).first
  end

  def previous
    self.class.where("id < ?", id).last
  end

end

Now you can do in your controller:

@product = Product.friendly.find(params[:id])

@previous_product = @product.next
@next_product = @product.previous

Please try it, but its not tested.
Thanks

More Related Contents:

  1. Is there a way to get a collection of all the Models in your Rails app?
  2. Eager load polymorphic
  3. accepts_nested_attributes_for with find_or_create?
  4. ActiveRecord.find(array_of_ids), preserving order
  5. Rails order by results count of has_many association
  6. Using Rails serialize to save hash to database
  7. Setting session timeout in Rails 3
  8. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  9. How to query a model based on attribute of another model which belongs to the first model?
  10. Multiple databases in Rails
  11. Rails: ActiveRecord query based on association value
  12. Rails 3, has_one / has_many with lambda condition
  13. Rails ActiveRecord: Find All Users Except Current User
  14. query , can not select column count
  15. How to use ActiveRecord in a ruby script outside Rails?
  16. Rails 4 nested attributes and has_many :through associaton in a form
  17. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  18. Validate uniqueness of multiple columns
  19. Rails: How do I create a default value for attributes in Rails activerecord’s model? [duplicate]
  20. Using helpers in model: how do I include helper dependencies?
  21. Rails – Validate Presence Of Association?
  22. delete_all vs destroy_all?
  23. Rails 3 migrations: Adding reference column?
  24. Converting an array of objects to ActiveRecord::Relation
  25. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  26. How to show SQL queries run in the Rails console?
  27. Rails: Overriding ActiveRecord association method
  28. How do I avoid a race condition in my Rails app?
  29. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)
  30. Specifying column name in a “references” migration

Leave a Comment