On May 4, 5:42 pm, JohnnyC <[email protected]> wrote:
>
> I'd like to retrieve those services whose products have overruns
> defined for them, and can do so by joining them with sql (no inner
> join) to restrict the result sets to only those that have entries in
> all 3.
>
> When I try to create a named_scope in the Service class as such:
>
> named_scope :has_overruns, { :joins =>
> [ :product, :product_overrun ] }
>
> .. it blows up with "ActiveRecord::ConfigurationError: Association
> named 'product_overrun' was not found; perhaps you misspelled it?"
The syntax for a nested join is the same as the syntax for a nested
include, in this case :joins => {:product => :product_overruns}. I've
got some more example of the syntax expected at
http://www.spacevatican.org/2008/8/8/nested-includes-and-joins
Fred
--
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.
