EJBQL equivalent of HQL's "WITH" keyword

martynez · **Joined:** Sun May 15, 2005 1:55 pm **Posts:** 2

I was wondering how to add an additional condition on a LEFT JOIN in EJBQL. In HQL, it's possible with the ``WITH'' keyword (let me use the reference example):

Code:

from Cat as cat 
    left join cat.kittens as kitten 
        with kitten.bodyWeight > 10.0

Is it possible to rewrite this to pure EJBQL? I've searched the PFD on Sun and have no idea. I need the query to return all cats even if a cat has no kitten with weight > 10.0. Unfortuneatelly it's not possible to use more than one query, since we need to use ORDER BY, setFirstResult() and setMaxResults().

Thanks for your ideas.

emmanuel · **Posted:** Sat Mar 25, 2006 8:41 am

nope this won't be part of the spec