OneData 10.7 | Managing Master Data with webMethods OneData | webMethods OneData User’s Guide | Advanced Object Properties | Using OneData Object Hyperlinks | Linking Data to a Record in Another Object
 
Linking Data to a Record in Another Object
You can create a link in one record to another record using the OD_LINK# tag. This tag dynamically links to the record or records that match the specified value. Use the following syntax to create a link to the record or records:
*To link to a unique record matching only one value, use the syntax: OD_LINK#\<ObjectName>\<ColumnName>=value\link description
*To link to a record where a column is not unique and matches more than one value, use the syntax: OD_LINK#\<ObjectName>\<ColumnName>=valueOD#PK#DELIMITER#OD<ColumnName>=value\link description
The following table describes the syntax of the OD_LINK# hyperlink.
Property
Description
Case Sensitive
OD_LINK#
Specifies a hyperlink to a record or records.
Yes
<Object$Name>
Logical, physical or display name of the object. Replace spaces in the object name with a $ symbol.
No
<Column$Name>
Physical column name. Replace spaces in the column name with a $ symbol.
No
Value
Returns the records that contain the value or values indicated.
No
OD#PK#DELIMITER#OD <Column$Name>=value
Delimiter for each column name when filtering on more than value, for example, when the values in a column are not unique. This syntax creates an and condition search.
Yes
Link Description
The hyperlink text. Replace spaces in the description with &nbsp;.
N/A
For example, to create a link to John Doe’s record in the Customer Account object, you would use the following command:
OD_LINK#\customer$account\first_name=johnOD#PK#DELIMITER#ODlast_name=doe\John&nbsp;Doe&nbsp;Account&nbsp;Record
OneData tags are case sensitive, but the object name, column names, and values are not. Replace spaces in an object name with the $ symbol and spaces in the description with &nbsp;.
*To create a link to records
1. Optionally, verify that the column in which you want to add a link is defined with the correct attributes. See Verifying the Column Definition.
2. On the Menu toolbar, click Manage > Manage Data or View > Browse.
3. Navigate to the object in which you want to add a link and select it.
4. Use the option that corresponds to the object’s display mode:
*In Default mode: click the Values tab.
*In Nova mode: click Apply Filter.
5. Click Insert > Insert or Insert > Insert Multiple.
6. In the relevant column, link to a record using the command that corresponds to whether you are filtering on one or more than one column:
*To filter on one column, where the column value is unique: OD_LINK#\<ObjectName>\<ColumnName>=value\link&nbsp;description
*To filter on more than one column where column values are not unique: OD_LINK#\<ObjectName>\<ColumnName>=valueOD#PK#DELIMITER#OD<ColumnName>=value\link&nbsp;description