Find non-empty association?


#1

I have two models, Category and Article. Article belongs_to :category
and Category has_many :articles. I’d like to be able to find all
non-empty categories. What’s the best way to do that?

Pat


#2

Am Mittwoch, den 01.03.2006, 04:14 -0700 schrieb Pat M.:

I have two models, Category and Article. Article belongs_to :category
and Category has_many :articles. I’d like to be able to find all
non-empty categories. What’s the best way to do that?

Category.find(
:all,
:include => :articles,
:conditions => ‘articles.category_id IS NOT NULL’
)

I think this might be the right clause. But i am not 100% sure.


Norman T.

http://blog.inlet-media.de


#3

On 3/1/06, Norman T. removed_email_address@domain.invalid wrote:

http://lists.rubyonrails.org/mailman/listinfo/rails

Thanks for the code bit. Unfortunately I’m not sure if it works,
because I’m using HABTM. Of course it was late and didn’t ask the
proper question…but is there a nice way to do it for a HABTM?

Pat