Data Director User Guide

10.5 HotFix 4

Back Next

Configuring the Root to Child Lookup

The instructions explain how to configure the root to child look up when you have a business entity as a

person

having the

person_party

as root and with the

electronic address

as the child field.

Add a new field to Party Base Object through the MDM Hub console.

Launch Hub Console.

Select any Operational Reference Store (ORS).

Navigate to the Schema from the Model.

Expand the Party Base Object

Click

Columns

Acquire Write Lock

Add a new field.

For instance, add a new field called

person_email

The following diagram shows a sample field creation:

The image shows the Schema Model selected under Workbench. On the Schema section under Party, the Columns option is selected. Under the Party Columns, a new field is entered for the Person_email with the nullable option selected, varchar data type, and length as 50.

Establish a relationship from the

person_email

Electronic Address

in the Party Electronic Address Base Object.

Under Relationships, select

Option

Acquire Write Lock

Click the

Add

icon.

The Add relationship dialog appears.

From the Relate From panel, select

person_email

From the Relate To panel, go to

Party_Electronic_Address

rowID Object

The following image shows how you can add the relationship:

Click

Select

Release Write Lock

Run the met validation.

The following validation image indicates the relationship created:

The image shows the Properties tab. Under the Table references section, you can see the following text: Foreign Key from "Party (Person_Email)" to "Party Electronic Address (Rowid Object)" (Restrict) [Virtual].

To reflect these changes in the Provisioning, create a new lookup and enable the Sibling Lookup option.

Launch the Provisioning tool.

Select the Operational Reference Store (ORS).

Go to

Modelling

Business Entities

Expand the root level lookup field folder from the middle panel.

Create a new lookup.

Enter the Sibling lookup name and label.

Enable the Sibling Lookup.

The following image shows how to enable the sibling reference:

The image shows that under Modelling, select the Business Entities. Under Person, the Phone folder appears. Under the Lookup fields, there is a Primary Phone folder. Under the Primary Phone section, the name and label is Primary phone. The sibling reference is selected. Object has the value as phone. Constraint is updated. The Lookup Display field is phoneNum.

Go to

Objects

Select Emails

On the Lookup display fields, go to

Select Electronic Address

Apply Changes

Publish the changes.

Log into Entity 360 to use the Sibling Configuration with the magnifying glass icon as seen in the following screenshot:

The image shows the business entity. On the Overview section, the primary phone is updated and appears with the magnifying glass and delete icons. The primary email appears without any value but appears with the magnifying glass and delete icons.

Click on the magnifying glass icon to see the list of email IDs created for a specific person.

The following image displays the list of email IDs created for a specific person:

Select one the emails added and click

In the example, since you selected the Lookup display field as Email Address in Provisioning, the value displayed in the

Person_Email

field is

email1@gmail.com

as seen in the following image:

Rename Saved Search

Table of Contents

Data Director User Guide

Data Director User Guide

Configuring the Root to Child Lookup

Configuring the Root to Child Lookup