Object Fields

In the Object Fieldscategory you can choose a placeholder for any object field. Fields from related objects are also available. For example, to insert the full name of the person who submitted the Problem related to the Incident, select the following:

  • Category: Object Fields
  • Item: Current Values
  • Subitem: Assignee > ID (Global ID - GUID)

This will insert the following placeholder:

%[DBF Related_Problem_ID.Requester_ID.Full_Name]%

Note that placeholders database object fields have the DBF prefix.

When you create SQL expressions for your workflow items or components, you may need to insert the primary key which uniquely identifies an object record in the database. In order to insert the primary key, use the ID (Global ID - GUID) placeholder, which is available for each subitem in the Object Fields category. For example, to insert the primary key which uniquely identifies the Person record selected as the Incident’s assignee, use the following:

  • Category: Object Fields
  • Item: Current Values
  • Subitem: Assignee > ID (Global ID - GUID)

This will insert the following placeholder:

    %[DBF Assignee_ID.ID]%

Some objects’ fields can contain links to related objects of different classes. For example, the Related CI field of a Ticket can contain a link to a Computer, Person, Software License, etc. These objects, in turn, may have different sets of fields. For example, a Computer has the CPU Speed field, while a Software License does not. So if you need to insert the value of such a field as a placeholder, you have to specify the class of the Related CI in the Subitem list (As Computer, As Software Licence, etc.). For example, to insert the CPU Speed of a Computer related to a Ticket, select the following:

  • Category: Object Fields
  • Item: Current Values
  • Subitem: Related CI > *AsComputer > CPU Speed

This will insert the following placeholder:

    %[DBF Related_CI_ID.*AsComputer.CPU_Speed]%

When you define expressions for use in Actions and Triggers that respond to object changes, sometimes you need to have the field’s original value. In this case choose Old Values in the Item pane, so the placeholder will be expanded with the original value of the field. For example, to insert the original Priority value for the Trigger that fires on changing the Incident Priority, select the following:

  • Category: Object Fields
  • Item: Old Values
  • Subitem: Priority > Priority

This will insert the following placeholder:

    %[DBF OLD.Priority_ID.Priority]%