cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hugi Thordarson <h...@karlmenn.is>
Subject Re: Expression to look for objects with an empty to-many relationship?
Date Fri, 24 Jul 2015 15:54:25 GMT
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 <andrus@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 <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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message