Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Query for union of child list
Date: Tue, 1 Jun 2010 09:14:09 -0700
Message-ID: 
 <E0529A8FFC2C9143A5F1BB9A89101D06099182C4@BD01MSXMB018.US.Cingular.Net>
In-Reply-To: <1275408055717-5126735.post@n2.nabble.com>
Thread-Topic: Query for union of child list
Thread-Index: AcsBo7aXDx8TO7T1SmiHQbCp3sto0QAAaS/g
References: 
 <E0529A8FFC2C9143A5F1BB9A89101D060985004D@BD01MSXMB018.US.Cingular.Net>
 <1275408055717-5126735.post@n2.nabble.com>
From: "KARR, DAVID (ATTSI)" <dk068x@att.com>
To: <users@openjpa.apache.org>

> -----Original Message-----
> From: Pinaki Poddar [mailto:ppoddar@apache.org]
> Sent: Tuesday, June 01, 2010 9:01 AM
> To: users@openjpa.apache.org
> Subject: Re: Query for union of child list
>=20
>=20
> > I need to get a list of all the unique "Foo" objects in the
> "childFoos"
> list for all "Device" objects.
>=20
>   JPA 2.0 introduced a new entity type expression for JPQL which may
be
> useful here.
>   I will expect something like (provided Product-Foo is a bi-
> directional
> relation)
>=20
>   String jpql =3D "select f from Foo f where f.parent =3D :subtype";
>   em.createQuery(jpql)
>      .setParameter("subtype", Device.class)
>      .getResultList();

Unfortunately, I'm limited to OpenJPA 1.x for now.  What I have works, I
just wanted to know if there was a better way to do it.