Databases Reference
In-Depth Information
To fully test thid formula, you need to create test cases to cover the following
scenarios:
•
OrderProcessedDate == Null
or
OrderReceivedDate == Null
•
OrderProcessedDate
and
OrderReceivedDate
both contain valid val-
ues
To test calculated fields, you don't have to use a Java client
that sends the test data to BAM through EMS. Instead, you
can simply use the BAM Architect web application to modify
specific data fields, which are a part of the calculation.
Testing lookup fields
internally uses the
LEFT OUTER JOIN
to determine the values of lookup fields.
So, from the quality-assurance perspective, the best way to verify the lookup
result is to run the SQL queries on BAM datasets.
In the
Bookstore Demo
application, the
Order
Data Object has a field called
CustomerMembership
, whose definition is as follows:
Lookup Data Object:
/BookstoreDemo/Customer
Lookup Field(s):
Membership
Matching fields:
CustomerID = CustomerID
