Managing Master Data with webMethods OneData : Working with webMethods OneData MDR : Object Definition Model Enhancement : Object Definitions : Adding a New Object and Creating a Drop-down Attribute
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.
Copyright © 2011-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback