Creating Object Relationships in Ivanti

In Ivanti, Many to Many Relationships between objects can be created. Since the relationship itself is not a Business Object, and cannot therefore be created/updated as other Business Objects can be, Precision Bridge has provided a 'Virtual' Target Form that can be used to create these relationships.

The #LINK_CREATOR Virtual Table

The #LINK_CREATOR can be selected as a target when creating a form mapping. Essentially this provides an interface into the Ivanti API that creates relationships between objects. Mappings created with this target will be shown as green in the list to distinguish them from 'regular' business object mappings.

#LINK_CREATOR has the following restrictions:

• Attachments are not supported
• Cannot be used as a lookup source
• Key mappings are not supported, relationships can only be created, not updated.
• Can only be used as a target, not a source

#LINK_CREATOR provides the following fields:

• link_id - This will be a concatenation of the object_id and related_object_id values and hence acts as the unique id for the source record. It need not be mapped.
• object_table - This is the name of the parent table (business object) for the relationship. It MUST be mapped and must be the name of a Business Object Type with an 's' appended. For example, if the business object type name is incident, set object_table to incidents
• object_id - The recId of the parent business object.
• related_object_id - The RecId of the related business object
• relationship_type - The name of the relationship that is being created. Must be a defined relationship for the Business object that uses the Link Table.

#LINK_CREATOR can only create relationships. If a relationship of the type specified already exists between the two objects the insert will be ignored. In this case however, Precision Bridge will still report the relationship as 'created'

Related Articles

Retrieving Object Relationship Information from Cherwell

Cherwell to Ivanti Link Migration Example