Rails gem rails3-jquery-autocomplete: How do I query multiple fields

by

Your pseudo attribute works only on records already retrieved, but it has no bearing on searching for records. Probably the easiest solution is a named named scope like:

 scope :search_by_name, lambda { |q|
   (q ? where(["first_name LIKE ? or last_name LIKE ? or concat(first_name, ' ', last_name) like ?", '%'+ q + '%', '%'+ q + '%','%'+ q + '%' ])  : {})
 }

Thus, a call like:

Person.search_by_name(params[:q])

will return an appropriate result set. It will also return all entries if no param was passed (or more specifically, this scope will add nothing extra), making it an easy drop-in for the index action.

More Related Contents:

  1. Rails ActiveRecord methods in different places [closed]
  2. Is there a way to get a collection of all the Models in your Rails app?
  3. Rails find_or_create_by more than one attribute?
  4. Using helpers in model: how do I include helper dependencies?
  5. How to implement Active Record inheritance in Ruby on Rails?
  6. Eager load polymorphic
  7. accepts_nested_attributes_for with find_or_create?
  8. ActiveRecord.find(array_of_ids), preserving order
  9. Rails has_many with dynamic conditions
  10. Rails order by results count of has_many association
  11. How to query a model based on attribute of another model which belongs to the first model?
  12. Multiple databases in Rails
  13. Rails: ActiveRecord query based on association value
  14. Rails 3, has_one / has_many with lambda condition
  15. query , can not select column count
  16. How to rename rails controller and model in a project
  17. How to use ActiveRecord in a ruby script outside Rails?
  18. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  19. Validate uniqueness of multiple columns
  20. Rails: How do I create a default value for attributes in Rails activerecord’s model? [duplicate]
  21. Rails – Validate Presence Of Association?
  22. Rails 3 migrations: Adding reference column?
  23. Converting an array of objects to ActiveRecord::Relation
  24. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  25. How to show SQL queries run in the Rails console?
  26. Rails: Overriding ActiveRecord association method
  27. How do I avoid a race condition in my Rails app?
  28. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)
  29. Rails Model has_many with multiple foreign_keys
  30. Specifying column name in a “references” migration

Leave a Comment