ActiveRecord query using multiple conditions

Question

I have a employee data base that captures all employees for all companies the companies are referenced by a company_id

I want to do something like this

sql = "SELECT race, `foreign`, id_number, company_id, COUNT(*) FROM `employees` WHERE company_id = 52 AND race = `African` AND `foreign` = 1 GROUP BY id_number;"
temp_arr = []
ActiveRecord::Base.connection.execute(sql).each {|int| temp_arr << int }

Like this

employee_ids = Employees.where(company_id: company_id and race: 'African' and foreign: 1).pluck(:id_number)

I keep getting the following error

ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column 'African' in 'where clause':

And have been reading the Ruby on Rails Guides and cant seem to find what i am looking for. sorry i have never done such a query before its probably formatted wrong or something

replace and with , so it looks like employee_ids = Employees.where(company_id: company_id, race: 'African', foreign: 1).pluck(:id_number) — jvnill
– jvnill, Commented Mar 13, 2013 at 7:48

Muhamamd Awais · Accepted Answer · 2013-03-13 07:49:05Z

8

You have to replace 'and' with ',' Try as follow;

employee_ids = Employees.where(company_id: company_id, race: 'African',  foreign: 1).pluck(:id_number)

answered Mar 13, 2013 at 7:49

Muhamamd Awais

2,38515 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

ActiveRecord query using multiple conditions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related