Mapping Fields to be Updated by a Transaction
When adding the transaction details, you can map fields to be updated by the transaction. Fields are defined in the mapping table on the Manage CMDB transaction details window.
For the transactions which delete items or links, the fields will firstly be updated to the values set in the mapping table, before the items/links are deleted. In the case of transactions which manage links between CMDB entities, you can map fields relating to the Link Details.
You can map the fields relating to the Transaction Details record(s) created by the particular asset management transaction.
You can map both standard data fields as well as custom fields added through the ASM Designer.
In the Mapping Table on the Transaction Details window, click the Add button.
From the Add Fields popup, select a field. The fields are filtered by the selected transaction type. Note that CTRL-SHIFT-click will allow you to select multiple records one record at a time. SHIFT-click will select all records within the first and second click.
For an Update Item transaction on a CMDB item, you can map the field Freeze Status to set the freeze status of the updated CMDB item. For a Create Link, Update Link, or Delete Link transaction, you can map the fields Impacts Upper and Impacts Lower to set the impact relationships of the links created, updated, or deleted by these transactions.
Click OK to add the selected fields to the mapping table.
To remove any mapped fields, select the field in the mapping table and click Remove.
For each mapped field, specify the value to be set in the field after the transaction in the Value column:
Select (Value) to specify a value (such as a CMDB Template for a CMDB item field).
Select a request field for a variable value, that is, the field will be updated with the value in the specified field at the time the transaction runs.
The (Advanced) option is available on selected asset management transactions. Selecting this option returns a value for the field based on rules you create in the rules builder.
If Quantity is changed, Create item for each field value is selected, then any item mapped to the Iterator entity will be removed from the Mapping Table. A warning will appear when change is attempted.
To set the condition for when the field will be updated to the specified value, select the checkbox in the Update column in the browse table. You can select from:
| Always | the field will be updated regardless of whether it is already assigned a value |
|---|---|
On Initial Population Only | the field will only be updated if it has never had a value before |
Only When Blank | the field will only be updated if it is currently blank |
Create Item for each field value | "Iterator" will appear as a selectable item. From there you can select "Current Value". Current value refers to the current item that is within a multiple value field that may be selected in the Quantity field. For example, if "Request CIs" is selected in the Quantity field, then "Iterator" is referring to Request CIs and "Current Value" is referring to the first, second, third and so on of the items in the Request CIs fields. If "Request CIs" is instead selected as the value for a mapped item, then the value of the created items will always be the value of the first item specified in "Request CIs." That is, it doesn't set the value according to the first, second, third and so on of the "Request CIs". If you change from Create item for each field value to another selection, then any item mapped to the Iterator entity will be removed from the Mapping Table. A warning will appear when change is attempted. |
The Update column is not displayed on the Mapping Table for the asset management transactions.
To specify that the transaction fails if encounters an error (such as when it cannot update a mapped field or a specified CMDB item), select the Error option.
Save the transaction details.