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 > > >