how to perform (not in) operation in outsystem9 without using advance sql

how to perform (not in) operation in outsystem9 without using advance sql

  
hello,

i want to perform not in operation in outsystem9 without using advance query.

Thanks,
Manish
Hi Manish,

The aggregates still don't have enough expressiveness to represent a NOT IN operation.
Technically, using the a With or Without Join and filtering for null identifiers on the joined table you could get the same result of a simple NOT IN of a single table ...but performance wise it would not be the same thing.

The best option to do a NOT IN operation is really to use an Advance Query.

Regards,
João Rosado