cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Expression to look for objects with an empty to-many relationship?
Date Fri, 24 Jul 2015 15:36:59 GMT
We should add it. For now OUTER JOIN should do the trick:

   "a.paintingArray+ = null"

Also EJBQL syntax supports "IS [NOT] EMPTY" :

   "SELECT a FROM Artist a WHERE a.paintingArray IS EMPTY"

Andrus

> On Jul 24, 2015, at 5:51 PM, Hugi Thordarson <hugi@karlmenn.is> wrote:
> 
> Hi all.
> Does Cayenne have an Expression class that allows searching for objects with an empty
to-many relationships? If not, any pointers towards a sensible approach?
> 
> Cheers,
> - hugi
> 
> // Hugi Thordarson
> // http://www.loftfar.is/ <http://www.loftfar.is/>
> // s. 895-6688
> 
> 
> 


Mime
View raw message