Bob type ADC export

The export of Bob type ADCs is a special case. See below for detailed explanation regarding the Bob Type ADC export.

A record is written with type as b, name as Bob element name, integer_value as Bob_id of the ADC field. Apart from this record, some other records are also created in this table for every element in the Bob (beyond changeTimestamp, and excluding activeStatus).

For example, if the ADC Bob is the Company Bob (as shown below), you must see rows for companyName and companyCode. These rows must follow the row for the Bob, and have a parent_bob_id = the Bob id of the Bob to which they belong. Moreover, this must happen recursively. If one of the elements of the ADC Bob is of type Bob, individual rows must exist for the elements of that Bob, and so on.

SQLWKS> select elem_name from almt_bob_elements where bus_obj_type_id = 28000

ELEM_NAME
type
uid
parent
command
version
ack
changeTimestamp
companyName
companyCode
activeStatus

All ADC elements of type Bob (ADC Bobs) that directly belong to the exported Bob have their parent_bob_id set to null. ADC elements that belong to ADC Bobs have the parent_bob_id set to the Bob ID of the ADC Bob to which they belong. This distinction is introduced to help distinguish between the two types of elements.