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 
  • Last modified: 2023/05/10 01:27