openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daryl Stultz <da...@6degrees.com>
Subject Re: JPQL to get association members, but only ones that fulfill a condition
Date Wed, 03 Feb 2010 20:00:23 GMT
On Wed, Feb 3, 2010 at 2:12 PM, KARR, DAVID (ATTCINW) <dk068x@att.com>wrote:

> So I changed my query to:
>
> select foo from packagepath.Foo foo left join fetch foo.childBars as bar
>   where foo.id=:id and current_date between bar.startDate and
> bar.endDate
>
> try this:

select distinct foo from packagepath.Foo foo
left join foo.childBars as bar
left join fetch foo.childBars
where foo.id=:id
and current_date between bar.startDate and bar.endDate

Notice "distinct". You might find it works without out it bug a bug will
bite you later...

I'm not sure if you are expecting to get a subset of foo.childBars. If you
are, this won't work.

-- 
Daryl Stultz
_____________________________________
6 Degrees Software and Consulting, Inc.
http://www.6degrees.com
mailto:daryl@6degrees.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message