Rails 3 – select with Include?

by

There is a select method in ARel, but you must use the correct table names (i.e. plural and beware if you have polymorphic models or if you’re using set_table_name or some other similar non-standard practice)

@items = Item.
  select('users.name', 'users.created_at', 'orders.created_at', 'suppliers.name', 'agents.name', 'manufacturers.name').
  where(:users => { :fulfilled => true }).
  includes(:orders => [:supplier, :agent], :manufacturer)

“We can use select with joins not includes” – @Bhavesh_A_P

Note:

As @Bhavesh_A_P pointed out above, select with includes does not produce consistent behavior. It appears that if the included association returns no results, select will work properly, if it returns results, the select statement will have no effect. In fact, it will be completely ignored, such that your select statement could reference invalid table names and no error would be produced. select with joins will produce consistent behavior.

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. belongs_to through associations
  12. Check if record exists from controller in Rails
  13. Validate uniqueness of multiple columns
  14. Rails – Validate Presence Of Association?
  15. How to implement bulk insert in Rails 3
  16. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  17. Specifying column name in a “references” migration
  18. Rails: Order with nulls last
  19. ActiveRecord OR query Hash notation
  20. Rails find_or_create_by more than one attribute?
  21. Is it possible to set ENV variables for rails development environment in my code?
  22. ruby on rails f.select options with custom attributes
  23. Rails ActiveRecord: Find All Users Except Current User
  24. How to get a Date from date_select or select_date in Rails?
  25. ActiveRecord serialize using JSON instead of YAML
  26. Rails 3 autoload
  27. Store the day of the week and time?
  28. How do I extract Rails view helpers into a gem?
  29. How to make Devise redirect after confirmation
  30. Customizing Devise error messages in Rails 3?

Leave a Comment