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

Reply via email to