How to write scope with belongs_to object?

Question

I have the following models

Models

Job
  belongs_to :company
Company
  has_many :jobs

Right now I select all the Jobs which have an accepted Company using the following method:

def self.with_accepted_company
  Job.all.reject {|job| job.company.state != "accepted" }
end

But I would like to use scope for that and use it with other scopes. Is this possible to write that scope in the Job model?

shadysayed · Accepted Answer · 2012-12-16T16:06:58.790

20

class Job
  scope :accepted_with_active_company, ->() {
    joins(:company).where('companies.state' => "accepted") 
  }
end

edited Dec 16 '12 at 16:06

answered Dec 15 '12 at 15:28

shadysayed

I get an error using this scope ```>> Job.accepted_with_active_company.inspect ActiveRecord::ConfigurationError: Association named 'companies' was not found; perhaps you misspelled it? from /Users/rege/.rvm/gems/ruby-1.9.3-p194@ckdatabase/gems/activerecord-3.2.8/lib/active_record/associations/join_dependency.rb:112:in `build' ``` – tomekfranek Dec 16 '12 at 11:38
3

The error message tells you that you don't have an association named :companies. The original code assumes it was a `has_many` relation but in face it is `belongs_to` what you should do is have joins(:company) instead of joins(:companies). I have edited the answer to reflect that – shadysayed Dec 16 '12 at 16:08

score 0 · Answer 2 · answered Jan 22 '20 at 14:17

0

Here's an alternative syntax for the where clause:

class Job
  scope :accepted_with_active_company, ->() {
    joins(:company).where(companies: { state: 'accepted' }) 
  }
end

answered Jan 22 '20 at 14:17

lucas

2 Answers2