# Hash and condition

**URL:** <https://www.ruby-forum.com/t/hash-and-condition/103465>\
**Category:** Rails\
**Created:** [May 6, 2007, 2:45pm UTC](https://www.ruby-forum.com/t/hash-and-condition/103465 "2007-05-06T14:45:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bolo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/898d66/32.png) [@Bolo](https://www.ruby-forum.com/u/Bolo)\
**Post date:** [May 6, 2007, 2:45pm UTC](https://www.ruby-forum.com/t/hash-and-condition/103465/1 "2007-05-06T14:45:36Z")

</div>

Hello

I would like to use hash in my condition

1. User.find(:all, :conditions=\>{:first\_name =\> ‘akhil’, :role =\>  
‘admin’})

it’s working

User.find(:all,  
:include =\> :profile,  
:conditions=\>{:band =\> ‘bolo’, :first\_name =\>  
‘akhil’, :role =\> ‘admin’})

When i try this will generate this SQL  
WHERE (users.“band” = ‘bolo’ AND users.“first\_name” = '‘akhil’ AND  
users.“role” = ‘admin’)

But i would like the finder generate this SQL  
WHERE (profiles.“band” = ‘bolo’ AND users.“first\_name” = '‘akhil’ AND  
users.“role” = ‘admin’)

How i can do that ?

Bolo

---

<div class="post-metadata">

**Author:** ![Bolo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/898d66/32.png) [@Bolo](https://www.ruby-forum.com/u/Bolo)\
**Post date:** [May 6, 2007, 2:53pm UTC](https://www.ruby-forum.com/t/hash-and-condition/103465/2 "2007-05-06T14:53:36Z")

</div>

It’s possible to do that ?

a = [“profiles.band” =\> “bolo”, “users.irst\_name” =\> “bolo”]  
User.find(:all,  
:include =\> a,  
:conditions=\>a)