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 operations with dates are not supported in 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))
Avoid using these expressions in subqueries
If the Aware IM Server is started when either LAN or Internet connection is up and then either LAN goes down or Internet is disconnected, the server goes down too
Start the Aware IM Server within the configuration that you intend to work with. For example, if you only use dial-up Internet connection occasionally make sure that you start the Aware IM Server first and then connect to the Internet. This way when you disconnect from the Internet Aware IM will continue to work properly.
Documents of MS Word type are not supported under Linux and Mac OS X operating systems (MS Word XML format can be used instead if browsers are running on the Windows platform)
None
Negated IN
expression is not supported in queries. For example, the following expression is not supported:
FIND Event WHERE NOT(LoggedInMember IN Event.Participants)
In many cases the negated IN
expression can be replaced by using the equivalent COUNT
or EXISTS
expression, for example:
FIND Event WHERE COUNT Member WHERE( Member IN Event.Participants AND Member=LoggedInMember) = 0
Printing of documents of MS Excel type from rules is not supported under Linux and Mac OS X operating systems
None
Printing of documents of HTML type from rules is not supported
None
If you drag the bottom line of the Summary pane in the Report/Presentation Designer the height of the Summary band is not changed even though it appears visually that it is.
Change height of the Summary band using Band Properties – see Setting Band Properties
Dragging bands in Report Designer to change their height is not supported on Mac OS X
Hold down Apple key and click on the band’s header to bring up the bands property dialog. Specify the height of the band in the dialog
If two business objects are related through a parent/child relationship (see Reference Attributes) and the reference attribute to a child is defined as “Required” it is impossible to add a new child instance from a form of the parent instance using Add New button (see working_with_references_in_the_operation_mode)
Do not force “Required” flag for reference attributes or create child instance first and then add it to a parent using Add button.
Sorting on reference attributes in a query will not work if query searches business object group. For example, sorting in the following query will not work if Account is business object group:
FIND Account ORDER BY Account.Owner.Name
Define a shortcut attribute and sort by it, for example:
FIND Account ORDER BY Account.OwnerName
Where OwnerName
is the shortcut to Account.Owner.Name
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
Use EXISTS
or COUNT
expressions, for example
FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0
The following functions and expressions are not supported if used in queries:
WAS CHANGED
WAS CHANGED TO
TYPE
OLD_VALUE
None
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)
Avoid using such constructs in queries