Databases Reference
In-Depth Information
Once we have specified the key, we need to specify the
Key Value
, which in our
case is the auction ID (as this is the same as the ListingID). To do this, click on the
calculator icon to launch the expression builder and specify the appropriate value in
the normal way.
Inserting a detail SDO into a master SDO
Once we have bound our entity variable to the underlying SDO, our
Auction Process
can access its content as if it were a local variable and also update it (with those
changes being reflected in the underlying database).
However, the interesting part of our scenario is that when the
Auction Process
evaluates a new bid, we want it to insert that bid into the BID table in the underlying
database. One way to do this would be to create a
bidViewSDO
entity variable and
use the
Create Entity
activity to insert it into the database, just as we did with
our listing.
However, you may recall that when we service-enabled our Listing Business
Component, we enabled master detail updates. This means that if we add a
bidViewSDO
to our
listingViewEV
entity variable, then it will also insert a
bid into our database table.
First, create a standard variable
bidView
. This should be a variable of type
Element
, where the element is the definition of a
bidViewSDO
(as circled
in the following screenshot). Then use either an
Assign
or
Transform
activity to populate it appropriately.