Ruby on Rails / SQL Query with

Question

I the following models

class Company < ActiveRecord::Base
    attr_accessible :name, address, ........

     has_many :employees
end

class Employee < ActiveRecord::Base
    attr_accessible :firstname, :lastname, :company_id, .............

    belongs_to :company

end

I have a string q and would like to select all the employees whos firstname lastname or company.name are like q, something along the line of this query non working query

Employee.where("firstname like ? or lastname like ? or company.name like ?", q,q,q)

What is the best way to achieve this with rails?

p.matsinopoulos · Accepted Answer · 2013-01-15 21:17:09Z

6

Try this one:

Employee.joins(:company).where("employees.firstname like ? or employees.lastname like ? or companies.name like ?", '%q%', '%q%', '%q%')

answered Jan 15, 2013 at 21:17

p.matsinopoulos

7,8426 gold badges48 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:43:08Z

0

as mentioned in this great answer, the way to go here is by using a search gem rather than an SQL.

the leading candidate is Thinking Sphinx.

another useful answer from the same thread would be: https://stackoverflow.com/a/4037835/690866 there he shows what you wanted to achieve, if i understand correctly..

hope it helps.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jan 15, 2013 at 21:27

Nuriel

3,7513 gold badges25 silver badges24 bronze badges

Collectives™ on Stack Overflow

Ruby on Rails / SQL Query with

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related