Nathan Long
Reputation: 126122
Can I use Ransack to search for the same value in multiple columns?
Can the Ransack gem generate a SQL search of multiple columns for the same value?
For instance, something like "users where the first name OR the last name contains 'James'".
Upvotes: 0
Views: 2296
Answers (1)
NARKOZ
Reputation: 27961
Yes, here is an example:
MyModel.search(:firstname_or_lastname_cont => "James").result
Upvotes: 9
Related Questions
- How to search with Ransack with multiple items from an array
- Rails Ransack gem: search for multiple values with one condition
- Search an array of values with Ransack
- Rails Ransack gem: search for multiple values by using only one select option
- Ransack, search multiple columns, one field, rails 3
- How can I use Ransack gem to search a date and another value types in multiple columns?
- Searching for records that match multiple search queries with Ransack
- Searching multiple fields with Ransack
- Rails Ransack - How to include multiple conditions with a ransacker
- Rails Ransack - How to search multiple values