Forum: Ruby on Rails named_scope on has_many, find all records that don't have elements in that association

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Gabriele T. (Guest)
on 2009-01-12 00:33
(Received via mailing list)
I have  a Customer model that has_many :addresses, is there a way (via
named scope or any other method that's ... ehm ... model side) to
obtain all the Customers that don't have any addresses at all (for
which the associated array would be empty)?

Thank you for the answer...
Harold (Guest)
on 2009-01-12 01:21
(Received via mailing list)
Thinking in SQL, you want to do this:

select * from customers left outer join addresses on
customers.address_id =
  where is null.

First thing that comes to mind here something like:
Customer.find(:all, :include => :address, :conditions => '
is null')

hope that helps,

On Jan 11, 5:32 pm, Gabriele T. <removed_email_address@domain.invalid>
This topic is locked and can not be replied to.