Rails – Sort by join table data

by

I would suggest to avoid using default_scope, especially on something like price on another table. Every time you’ll use that table, join and ordering will take place, possibly giving strange results in complex queries and anyway making your query slower.

There’s nothing wrong with a scope of its own, it’s simpler and it’s even clearer, you can make it as simple as:

scope :ordered, -> { includes(:availabilities).order('availabilities.price') }

PS: Remember to add an index on price; Also see other great answers in here to decide between join/include.

More Related Contents:

  1. Rails :include vs. :joins
  2. Rails has_many :through Find by Extra Attributes in Join Model
  3. using has_many :through and build
  4. Begin, Rescue and Ensure in Ruby?
  5. How to “pretty” format JSON output in Ruby on Rails
  6. Rails :dependent => :destroy VS :dependent => :delete_all
  7. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  8. In Rails, how do you render JSON using a view?
  9. Rails sessions current practices
  10. Heroku upload-Precompiling assets failed
  11. What tools do you recommend to profile Rails apps? [closed]
  12. Rails ActiveRecord: Find All Users Except Current User
  13. Rails: around_* callbacks
  14. Undefined method raise_in_transactional_callbacks=’ for ActiveRecord::Base:Class (NoMethodError)
  15. How to avoid NoMethodError for nil elements when accessing nested hashes? [duplicate]
  16. Add a default value to a column through a migration
  17. Rails: How to change the title of a page?
  18. delete_all vs destroy_all?
  19. Best practices to handle routes for STI subclasses in rails
  20. To use self. or not.. in Rails
  21. NoMethodError when trying to invoke helper method from Rails controller
  22. Why not use shared ActiveRecord connections for Rspec + Selenium?
  23. How can I format the value shown in a Rails edit field?
  24. How to pass arguments into a Rake task with environment in Rails? [duplicate]
  25. Is there a way to avoid automatically updating Rails timestamp fields?
  26. Unpermitted Parameters adding new fields to Devise in rails 4.0
  27. macOS, Rails: “Failed to build gem native extension”
  28. Ruby on Rails: Advanced search
  29. Rails attachments inline are not shown correctly in gmail
  30. ImageMagick – “CORE_RL_magick_.dll not found” or how to install RMagick on windows with ruby 1.9.2

Leave a Comment