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 

Work Around

Use EXISTS or COUNT expressions, for example

FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0 
  • Last modified: 2023/05/10 01:31