# Find non-empty association?

**URL:** <https://www.ruby-forum.com/t/find-non-empty-association/75180>\
**Category:** Rails\
**Created:** [March 1, 2006, 12:15pm UTC](https://www.ruby-forum.com/t/find-non-empty-association/75180 "2006-03-01T12:15:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pergesu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/22d042/32.png) [@pergesu](https://www.ruby-forum.com/u/pergesu)\
**Post date:** [March 1, 2006, 12:15pm UTC](https://www.ruby-forum.com/t/find-non-empty-association/75180/1 "2006-03-01T12:15:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pergesu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/22d042/32.png) [@pergesu](https://www.ruby-forum.com/u/pergesu)\
**Post date:** [March 1, 2006, 12:42pm UTC](https://www.ruby-forum.com/t/find-non-empty-association/75180/2 "2006-03-01T12:42:38Z")

</div>

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](http://blog.inlet-media.de)

---

<div class="post-metadata">

**Author:** ![pergesu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/22d042/32.png) [@pergesu](https://www.ruby-forum.com/u/pergesu)\
**Post date:** [March 1, 2006, 8:51pm UTC](https://www.ruby-forum.com/t/find-non-empty-association/75180/3 "2006-03-01T20:51:03Z")

</div>

On 3/1/06, Norman T. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> [http://lists.rubyonrails.org/mailman/listinfo/rails](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