, , ,

Negated IN Expressions

Problem/Limitation Description

Negated IN expression is not supported in queries. For example, the following expression is not supported:

FIND Event WHERE NOT(LoggedInMember IN Event.Participants) 

Work Around

In many cases the negated IN expression can be replaced by using the equivalent COUNT or EXISTS expression, for example:

FIND Event WHERE COUNT Member WHERE( Member IN Event.Participants AND Member=LoggedInMember) = 0