{{tag>Known_Issues, Issue:In, Issue:Negation, Issue:Query}}
<invisible> This is the template for INHERITED known issues pages - add a tag to Issue: to allow this to show on the tagged page</invisible>

==== Negated IN Expressions ====
<grid>
<col sm="1"><invisible> This is a spacer column</invisible></col>

<col sm="5">===Problem/Limitation Description===
Negated ''IN'' expression is not supported in queries. For example, the following expression is not supported:<code aim>FIND Event WHERE NOT(LoggedInMember IN Event.Participants) </code> 
</col>

<col sm="1"><invisible> This is a spacer column</invisible></col>

<col sm="5">===Work Around===
In many cases the negated ''IN'' expression can be replaced by using the equivalent ''COUNT'' or ''EXISTS'' expression, for example:<code aim>FIND Event WHERE COUNT Member WHERE( Member IN Event.Participants AND Member=LoggedInMember) = 0 </code>
</col>
</grid>