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:59:39 GMT
Classic open source - "scratch your own itch" :) 


> On Jul 24, 2015, at 6:54 PM, Hugi Thordarson <hugi@karlmenn.is> wrote:
> 
> 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
View raw message