Adding a New Object and Creating a Drop-down Attribute
Example Scenario: Add a Character Set drop-down attribute to the 'Value Domain' object.
To add a create object and create a drop down attribute
1. On the Menu toolbar, click Define > Objects.
2. Click the folder General Lookup Table Maintenance.
3. Click Add Object.
4. Enter the attributes as follows.
Field | Value |
Name | Character Set |
Definition | Character Set of the Value Domain |
Owner/Steward | admin |
Skip Initial Filter Tab | Select this option. |
Physical Table | CHAR_SET |
Enable Workflow Email | Select this option. |
5. Click Save.
6. Next, add the table structure. On the Structure tab, click Add Column for each of the following:
Column Name | Data Type |
ID | Optional Database Sequence |
Name | Varchar 30 |
Description | Varchar 255 |
7. Click Create Table and confirm the change.
8. Define the primary key as follows:
a. On the Structure tab, click Edit Constraints.
b. Define the primary key as the ID column and click Save.
9. Add a foreign key constraint to Value Domain, as follows:
a. Navigate to the Value Domain object in the Base Objects folder.
b. On the Structure tab, click Edit Constraints.
c. Click Add new Foreign Key constraint.
d. Set the following fields:
Field | Value |
Related Table Name | Character Set |
Related Column Description | CHAR_SET_DESC |
Related Field | CHAR_SET_ID (newly created column) |
Display Options | Show as dropdown |
e. Click Save.
In Data Manager of the Administered Items object, edits on any Value Domain, the Value Domain details display the Character Set column as drop-down.
Contact Support
|
Community
|
Feedback