Related Object Type, Related Object Property AND Related Object Relationship
In MM one object may relate to some other object(s). We call the latter related object(s) of the current object. The relationship between the current object and its related objects is called the related object type.
For example, a table Customer may have columns such as CustomerId, Name, Address, etc. These columns are the table Customer's related objects. The related object type is Children.
The related object types are a subset of the system attributes. These are the related object types currently available:
- Children: children of the current object
- Parent: parent of the current object
In some cases, the user wants to select or filter on the properties of the related objects. We call the property of a related object a related object property. For example, Parent."Object Type" refers to the object type of the parent.
Here is a list of properties defined on each of the related object type:
Related Object Type | Related Object Properties |
Children (Deprecated) | System Attribute, profile attribute, data profiling attribute, custom attribute, custom relationship, and udp |
Parent | System Attribute, profile attribute, custom attribute, custom relationship, and udp |
The user may also select on the relationships of the related objects. We call the relationship of a related object a related object relationship. For example, Parent."Is Defined By" refers to the terms used to classify the parent of the current object. The value of a relationship or related object relationship is an array of objects of the type of Entity.
A related object type can be used as a system attribute by itself or as a related object property of another related object type or the same related object type. When a related object type is used as a system attribute or a related object property, its value is the same as the Name system attribute of the related object(s). For example, the system attribute Parent of the EmployeeId column is "Employees", which is the name of the Employees table.
We only support related objects of one level. I.e. we do not support the following: Parent.Parent. "Object Type".