Known Bugs and Limitations
<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>
<invisible> This is the template for known issues pages - add a tag to Issue: to allow this to show on the tagged page</invisible>
Applicability Rules & IS UNDEFINED
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
Arithmetic In Find
<invisible> This is the template for INHERITED pages</invisible>
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)
<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>
Functions Exclusive To Cloudbase Derby
The following functions are supported only in Cloudscape/Derby database:
WORD_NUMBER
WORDS_FROM_LEFT
WORDS_FROM_RIGHT
None
<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>
Function Limitations In Subqueries
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))
<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>
Loss Of LAN Connection
<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>
Printing HTML Documents From Rules
<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>
Report Summary Pane Resizing In Mac
<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>
Report Band Resizing In Mac
<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>
Required With Owned By References
<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>
Sorting References In Business Object Group Queries
FIND Account ORDER BY Account.Owner.Name
FIND Account ORDER BY Account.OwnerName
Where OwnerName is the shortcut to Account.Owner.Name
<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
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
<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>
Unsupported Functions In Queries
WAS CHANGEDWAS CHANGED TOTYPEOLD_VALUE
<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>
Use Of IN With Complex Identifiers
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)