Known limitations of AwareIM, with the workaround for each where one exists.
Using IS UNDEFINED in an applicability rule will not have the expected results when the attribute is a reference attribute.
Event.Organiser IS UNDEFINED
Refer to an attribute on the reference attribute instead
Event.Organiser.ID IS UNDEFINED
FIND action, for example using the following will not work:
FIND Account WHERE Account.Date=CURRENT_DATE-1
Use functions with dates (such as DATE_ADD) instead of arithmetic operations, for example:
FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE,-1)
The following functions are supported only in Cloudscape/Derby database:
WORD_NUMBER
WORDS_FROM_LEFT
WORDS_FROM_RIGHT
None
MIN, MAX and AVG expressions are not supported if used in subqueries on groups. For example the following query is not supported if Transaction is a group:
FIND Account WHERE (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000))
FIND Account ORDER BY Account.Owner.Name
FIND Account ORDER BY Account.OwnerName
Where OwnerName is the shortcut to Account.Owner.Name
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
EXISTS or COUNT expressions, for example
FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0
WAS CHANGEDWAS CHANGED TOTYPEOLD_VALUE
IN expressions using complex identifier of the reference list are not supported if used in subqueries. For example, the following query is not supported:
FIND Client WHERE (COUNT Account WHERE (Account IN Client.Carrier.Accounts) > 3)
Note that the following query is supported:
FIND Client WHERE (COUNT Account WHERE (Account IN Client.Accounts)>3)