{{tag>Known_Issues Issue:References Issue:UNDEFINED}}
<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>

====== Undefined With Multiple References ======
<row>
<col size="1"><invisible> This is a spacer column</invisible></col>

<col size="5"><heading size="4">Problem/Limitation Description</heading>
Checking for ''UNDEFINED'' value of a multiple reference attribute (see [[2000_concepts:0200_basics:0400_reference_attributes|Reference Attributes]]) in queries does not work correctly. For example, the following will not work:<code aim>FIND Account WHERE Account.Transactions IS UNDEFINED </code>
</col>

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

<col size="5"><heading size="4">Work Around</heading>
Use ''EXISTS'' or ''COUNT'' expressions, for example<code aim>FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0 </code>

</col>
</row>