# Problems when using conditions in find Rails 2.1.0

**URL:** <https://www.ruby-forum.com/t/problems-when-using-conditions-in-find-rails-2-1-0/145681>\
**Category:** Rails\
**Created:** [August 12, 2008, 9:44pm UTC](https://www.ruby-forum.com/t/problems-when-using-conditions-in-find-rails-2-1-0/145681 "2008-08-12T21:44:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![staypufd](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@staypufd](https://www.ruby-forum.com/u/staypufd)\
**Post date:** [August 12, 2008, 9:44pm UTC](https://www.ruby-forum.com/t/problems-when-using-conditions-in-find-rails-2-1-0/145681/1 "2008-08-12T21:44:52Z")

</div>

Never had this issue before updating to Rails 2.1.0. Now for some reason  
the condition clause used with an array is not working. I’ve been trying  
use work arounds but I can’t figure it out. Please anyone HELP!!!

Query in question.

@furnii\_from\_furnii = Furni.find(:all, :include =\> [:raider],  
:conditions =\> “”+Furni.conditions\_by\_like(@search)+" OR "  
+Raider.conditions\_by\_like(@search)+"")

---

<div class="post-metadata">

**Author:** ![staypufd](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@staypufd](https://www.ruby-forum.com/u/staypufd)\
**Post date:** [August 13, 2008, 1:48am UTC](https://www.ruby-forum.com/t/problems-when-using-conditions-in-find-rails-2-1-0/145681/2 "2008-08-13T01:48:45Z")

</div>

I do not understand why do you want conditions\_by\_like kind of  
functions,  
but anyways.

A very crude way(which I hate):

@furnii\_from\_furnii = Furni.find(:all, :include =\> [:raider],  
:conditions =\> “#{Furni.conditions\_by\_like(@search)} OR  
#{Raider.conditions\_by\_like(@search)}”)

You can check the implementation of these methods as well:  
Furni.conditions\_by\_like(@search)  
Raider.conditions\_by\_like(@search)

Gourav

On Aug 12, 3:44 pm, Sam G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![staypufd](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@staypufd](https://www.ruby-forum.com/u/staypufd)\
**Post date:** [August 13, 2008, 1:13pm UTC](https://www.ruby-forum.com/t/problems-when-using-conditions-in-find-rails-2-1-0/145681/3 "2008-08-13T13:13:24Z")

</div>

Gourav T. wrote:

> I do not understand why do you want conditions\_by\_like kind of  
> functions,  
> but anyways.
> 
> A very crude way(which I hate):
> 
> @furnii\_from\_furnii = Furni.find(:all, :include =\> [:raider],  
> :conditions =\> “#{Furni.conditions\_by\_like(@search)} OR  
> #{Raider.conditions\_by\_like(@search)}”)
> 
> You can check the implementation of these methods as well:  
> Furni.conditions\_by\_like(@search)  
> Raider.conditions\_by\_like(@search)
> 
> Gourav
> 
> On Aug 12, 3:44 pm, Sam G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

Thanks. The problem was different. in Rails 2.1.0 you have to specify  
the table name when you do an eager loading. In regards to why I’m using  
a condition\_by\_like function is that I’m doing a small search where I do  
not need ferret or sphinx implementation. The condition\_by\_like allows  
me to loop through columns in tables and also split the search word. So  
there you have it. If you have a better way please let me know. I’m  
interested in all options.