[Rails] scopes related question

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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.