This is an old revision of the document!


<columns 100% 4% 48%>

<newcolumn>

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 

<newcolumn>

Work Around

Use EXISTS or COUNT expressions, for example

FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0 

<newcolumn> </columns>

  • Last modified: 2023/03/09 03:35