You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by David E Jones <de...@me.com> on 2010/04/12 23:35:59 UTC

Re: given a list of facilityIds can I do a DB query and get a list of corresponding facility entities

Use the IN operator.

-David


On Apr 12, 2010, at 2:47 PM, Patrick wrote:

> I have a list of facilityIds and I want the entities.   I know I could
> put it in a for loop and do x number of database queries, but I was
> hoping there was a faster way since I know that DB queries are the
> bottleneck.  Thanks
> Patrick