Thanks Andrus, we’ll revert to EJBQL for now. Looks like an excellent opportunity to try and implement my first Expression class :)
- hugi > On 24. júl. 2015, at 15:36, Andrus Adamchik <and...@objectstyle.org> wrote: > > 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 >> >> >> >