Negated IN
expression is not supported in queries. For example, the following expression is not supported:
FIND Event WHERE NOT(LoggedInMember IN Event.Participants)
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