Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of robert.zeigler@gmail.com
 designates 209.85.132.244 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:in-reply-to:content-type
         :content-transfer-encoding:mime-version:subject:date:references
         :x-mailer;
        b=fU8cItgtKrjFXC458qMqaHi/NP7uwC/3pp+7QMVRPr6dQWJGqPuslEM0NrnPWPnJXH
         U5YNP7h+29cTaf63JixNZDdxOeg6Jy8KOfPkgTQzvLWloECTC12Nv9ymm2lQ4MRmYt/V
         tw9oncmIlXKz24PcEgkUi6vAhydL9MWvn4aQE=
Message-Id: <45F555BA-7356-4037-9F62-75893526E518@puregumption.com>
From: Robert Zeigler <robert.zeigler@gmail.com>
To: user@cayenne.apache.org
In-Reply-To: <85996577-B7D6-4904-9DD1-CD5C427FDD76@earthlink.net>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v930.3)
Subject: Re: Qualifier Expression
Date: Sat, 14 Mar 2009 14:53:05 -0500
References: <85996577-B7D6-4904-9DD1-CD5C427FDD76@earthlink.net>

Hi Joe,

How about:

SelectQuery query = new SelectQuery(Entity1.class);
query.setQualifier(ExpressionFactory.matchExp(Entity1.EN| 
TITY2_PROPERTY,entity2));//where ENTITY2_PROPERTY is the name of  
object property in entity1 that points to entity2
List<Entity1> e1 = objectContext.performQuery(query);//note: perform  
query is NOT generified, so you'll get a warning here.

Robert

On Mar 14, 2009, at 3/141:29 PM , Joe Baldwin wrote:

> I am attempting to create the simplest Cayenne-expedient method of  
> doing the following query. (I can easily do this in SQL but am a tad  
> confused with the Cayenne Expression method.)
>
> I have an Entity (E1) with a one to one relationship with a second  
> entity (E2).  I would like to perform a SELECT Query with a filter  
> on one of the fields of the relationship-entity (E2.F1) and return a  
> list of the first entity (E1List).
>
> What is the most efficient Cayenne way to do this?  (I am still a  
> bit confused concerning how to construct efficient queries in the  
> object domain vs the relational domain.)
>
> Thanks,
> Joe
>
>
>