This is the template for INHERITED known issues pages - add a tag to Issue: to allow this to show on the tagged page
Negated IN Expressions
This is a spacer column
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)
This is a spacer column
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