# Apply more than one condition to a find(:all

**URL:** <https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506>\
**Category:** Rails\
**Created:** [June 5, 2006, 6:10pm UTC](https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506 "2006-06-05T18:10:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![scott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3e96dc/32.png) [@scott](https://www.ruby-forum.com/u/scott)\
**Post date:** [June 5, 2006, 6:10pm UTC](https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506/1 "2006-06-05T18:10:22Z")

</div>

Hi

I have the find statement below, how can I apply another condition to  
this to say AND status \> 3

@projectReport = Project.find(:all, :conditions =\> ‘status != 7’)

Thanks  
scott

---

<div class="post-metadata">

**Author:** ![scott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3e96dc/32.png) [@scott](https://www.ruby-forum.com/u/scott)\
**Post date:** [June 5, 2006, 6:18pm UTC](https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506/2 "2006-06-05T18:18:38Z")

</div>

@projectReport = Project.find(:all, :conditions =\> ‘status != 7 AND  
active = 1’)

scott wrote:

> Hi
> 
> I have the find statement below, how can I apply another condition to  
> this to say AND status \> 3
> 
> @projectReport = Project.find(:all, :conditions =\> ‘status != 7’)
> 
> Thanks  
> scott

---

<div class="post-metadata">

**Author:** ![scott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3e96dc/32.png) [@scott](https://www.ruby-forum.com/u/scott)\
**Post date:** [June 5, 2006, 6:19pm UTC](https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506/3 "2006-06-05T18:19:35Z")

</div>

On 6/5/06, scott [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> –  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

:conditions just throws in a WHERE clause.

@projectReport = Project.find(:all, :conditions =\> ‘status != 7 AND  
status \> 3’)

---

<div class="post-metadata">

**Author:** ![scott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3e96dc/32.png) [@scott](https://www.ruby-forum.com/u/scott)\
**Post date:** [June 5, 2006, 6:22pm UTC](https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506/4 "2006-06-05T18:22:47Z")

</div>

On Jun 5, 2006, at 9:10 AM, scott wrote:

> I have the find statement below, how can I apply another condition to  
> this to say AND status \> 3
> 
> @projectReport = Project.find(:all, :conditions =\> ‘status != 7’)

@projectReport = Project.find(:all, :conditions =\> ‘status != 7  
and status \> 3’)

🙂

–  
– Tom M.

---

<div class="post-metadata">

**Author:** ![scott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3e96dc/32.png) [@scott](https://www.ruby-forum.com/u/scott)\
**Post date:** [June 5, 2006, 6:20pm UTC](https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506/5 "2006-06-05T18:20:21Z")

</div>

Sorry, I didn’t see the specific thing you wanted to do

@projectReport = Project.find(:all, :conditions =\> ‘status != 7 AND  
status \> 3’)

ryan wrote:

> @projectReport = Project.find(:all, :conditions =\> ‘status != 7 AND  
> active = 1’)
> 
> scott wrote:
> 
> > Hi
> > 
> > I have the find statement below, how can I apply another condition to  
> > this to say AND status \> 3
> > 
> > @projectReport = Project.find(:all, :conditions =\> ‘status != 7’)
> > 
> > Thanks  
> > scott

---

<div class="post-metadata">

**Author:** ![scott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/3e96dc/32.png) [@scott](https://www.ruby-forum.com/u/scott)\
**Post date:** [June 5, 2006, 6:26pm UTC](https://www.ruby-forum.com/t/apply-more-than-one-condition-to-a-find-all/62506/6 "2006-06-05T18:26:52Z")

</div>

thats great,

thanks