On 13 July 2010 13:03, Greg Ma <[email protected]> wrote:
> Colin Law wrote:
>> On 13 July 2010 10:36, Greg Ma <[email protected]> wrote:
>>>> Colin
>>>
>>> Yes I know that but I'm not trying to get Products but Categories with
>>> products
>>
>> I thought you meant "categories (along) with (their) products".
>> Do you mean that you want all the categories that have at least one
>> product, ie where category.products.count > 0?
>>
>> Colin
>
> That doesnt work either, that tells you if the current category has more
> than one products.
> And I want all the categories which has at least one product.
I did not say that is the solution, I asked whether you were trying to
find all categories that meet that condition, to which I think the
answer is yes.
I suggest getting it working in a find first, then convert it to a
named scope. You could use something like
Category.find( :all, :include => :products ).select { |c| c.products.count > 0 }
Colin
--
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.
