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 <h...@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
> 
> 
> 

Reply via email to