IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > JDBC > Overview of IBM WebSphere Adapter for JDBC > Technical overview > Outbound processing
Matching records using child business object attributes
IBM WebSphere Adapter for JDBC supports matching records using the child business object attributes on RetrieveAll, DeleteAll, Exists, and UpdateAll operations.
When you specify the attributes in the child business object of the input business object, the adapter matches the top-level business object by join search on the child business object.
- Child business object attributes set in a single instance
If you specify child business object attributes in a single child business object instance, the adapter uses the equal operator (=) to match the child business object attributes, and generates the AND logic for the matching rules. In the example shown in Figure 1, the adapter queries to retrieve all customer records, where the company equals “XYZ” and the customertype equals “VIP”.
Figure 1. Retrieving records using attributes set in a single child business object instance
- Child business object attributes set in different instances
of the same child business object
If you specify child business object attributes in different instances of the same child business object, the adapter generates the AND logic for the attributes set in the same instance and generates the OR logic for different instances. In the example shown in Figure 2, the adapter queries to retrieve all customer records where the company equals “XYZ” and the customertype equals “VIP”, or the company equals “ABC” and the customertype equals “VVIP".
Figure 2. Retrieving records using attributes set in different child instance
Related concepts: