Aggregate only without

Aggregate only without

  

Hello. I`m newbie in Outsystems. Please help me to find out how to create such an aggregate with join like only without. I think it could be like a SQL EXCEPT query. Thanks.

Solution

Hi Vyacheslav,

The common way to do that is to LEFT JOIN the target Entity (so "With or Without" in the Aggregate) and add a Filter that filters on an empty value, e.g. Entity.Id = NullIdentifier().

Solution