figured out the answer to this problem. I needed to use :joins to include associated models in scopes.
On Oct 11, 10:05 pm, slava <[email protected]> wrote: > Hello, > Have a question related scope definition. I need to define a scope > based on related model attribute values like this. > > class Product < ActiveRecord::Base > belongs_to :currency > > scope :with_currency, lambda { |currency| > unless currency.to_s.upcase == 'ALL' > > # here I need to define a scope that would test for currency.char_code > to match a passed value > # something like.. This is where I need help > where("currency.char_code = ?", currency.to_s.upcase) > end > } > > end > > class Currency < ActiveRecord::Base > attr_accessor : char_code > end > > class LineItem < ActiveRecord::Base > belongs_to :product > > scope :with_currency, lambda { |currency| > unless currency.to_s.upcase == 'ALL' > > # here is another scope where I need help.. > where("product.currency.char_code = ?", currency.to_s.upcase) > end > } > > end > > Thanks for suggestions. Still learning the scoping magic. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
