Re: [eclipselink-users] Expression API - Subquery referencing parent que

[Tom Ware <tom.ware@xxxxxxxxxx>]

JPQL like what you have written below should work.  Are you having an issue?

Tim Hollosy wrote:
> I'm not sure what this is called, but is it possible to create sql
> like this with the expression API?
>
> select * from department d
> where
> exists (select 1 from employee e where e.department_id = d.department_id)
>
> This is important when to do when you're paging parent data but want
> to search inside child data.
>
> Thanks!
> Tim
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users