Rails - May 2009 - HABTM: AND on associated table records

In my application i have the following models:

Item - has_and_belongs_to_many :orders
Order - has_and_belongs_to_many :items

This is a basic setup for a small shopping app, I can successfully
add/remove/edit a list of items to one or more orders, but now from the
administration i need to be able to perform a search like: "show orders
having (at least) item x and item y and item z (or more)"

Basically, i need to use AND conditions for items belonging to orders,
something like Order.find(:all, :conditions => "items.id = 2 AND
items.id = 5 AND ...", :include => [:items]) .
Obviously the query above doesn''t work, but I can''t figure out
how to do
that.

Any suggestions?

Thanks in advance
-- 
Posted via http://www.ruby-forum.com/.

I think that the condition that you are looking for is:

:condition => item.id in (2,4,6,11,...etc.)

Bharat Ruparel wrote:
> I think that the condition that you are looking for is:
> 
> :condition => item.id in (2,4,6,11,...etc.)
Thanks for your answer.
This performs a OR, find all Ordrers having at least one of the ids 
specified inside IN() .
-- 
Posted via http://www.ruby-forum.com/.

I think you can do it the other way around, do the find on the items, where
the item id is in one of the set. Then the orders you are looking for are
the ones in the returned rows as item.order. Then you just need to select
the unique orders.

Colin

2009/5/11 Serafino Picozzi
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
>
> Bharat Ruparel wrote:
> > I think that the condition that you are looking for is:
> >
> > :condition => item.id in (2,4,6,11,...etc.)
>
> Thanks for your answer.
> This performs a OR, find all Ordrers having at least one of the ids
> specified inside IN() .
> --
> Posted via http://www.ruby-forum.com/.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---