<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
<invisible> This is a spacer column</invisible>
===Problem/Limitation Description===
Checking for
UNDEFINED value of a multiple reference attribute (see Reference Attributes) in queries does not work correctly. For example, the following will not work:
FIND Account WHERE Account.Transactions IS UNDEFINED
<invisible> This is a spacer column</invisible>
===Work Around===
Use
EXISTS or COUNT expressions, for example
FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0