Servicenow reference field display value

Select a field as the table display value

Only one field can be defined as the display value for a table.

Before you begin

Role required: personalize_dictionary

About this task

When you set the Display value to true, a business rule sets the Display value to false for all other fields on the table. In previous versions, you must manually ensure that no other fields on the table have a value of true in the Display column.

Note: Extended tables inherit the display value of the parent table. Setting a separate display value for the extended table overrides the parent table's display value.

Procedure

  1. Navigate to .
  2. Filter on [Table] [is] [<name of the referenced table>].
  3. Locate the desired field and set Display to true.

    For best results, choose a field that is required and unique in each record as the display value field.

    Set display

    Note: If you make a field the display field for a table, be sure to translate all values for the field in the Translated Text [sys_translated_text] table into all the languages provided. Display field options left untranslated are not presented by the autocomplete (type ahead) feature.

    Reference fields look for the display value in the following order:
    1. A field with display=true in the system dictionary on the lowest sub-table for extended tables.
    2. A field with display=true in the system dictionary on the parent table.
    3. A field named name or u_name.
    4. The Created on field of the referenced record.
Sours: https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/field-administration/task/t_SelectTheDisplayValue.html

In ServiceNow, all information is stored in tables. The tables refer to each other with reference fields. This documentation shows you how to send and update reference fields with Exalate for ServiceNow.

Read more about reference fields in the ServiceNow Reference field documentation.

') }); //]]>

Sending Reference Fields

ServiceNow REST API returns different results when the field is empty or not empty:

  • If the field is empty, it returns an empty string value.
  • If the field is not empty, it returns an object with the display value and a link to the reference field table.

To send a reference field, we need to make sure that it is not empty with a script:

//Outgoing script if(incident.caller_id && incident.caller_id != ""){    //We only get inside this block if the caller_id has a value    replica.caller = incident.caller_id.display_value }
The script returns the display value.

In some cases, we need to retrieve other information with the display value. To do so, we can use a link to the table and . This method will get the full content of the reference field.

Example:

//Outgoing script if(incident.caller_id && incident.caller_id != ""){ //We only get inside this block if the caller_id has a value replica.callerMail = nodeHelper.getTableByLink(incident.caller_id?.link)?.email }
You can replace the value to get other information, for example, a user name.

If you want to get a specific value from the table, you can use . In the script, you can specify the table name.

Example:

//Outgoing script replica.johnUserName = nodeHelper.getReference("sys_user", "email", "[email protected]")?.name
You can replace the following parameters:
Name of the table.
Name of the table column.
The value in the column.

You can update reference fields by using their value.

Example of getting the field status:

//Incoming Script incident.incident_state = "9"

You can also retrieve the reference id by using specific values from a table and a column.

Example:

//Incoming script def remoteEmail = replica.reporter?.email if(remoteEmail){ incident.caller_id = nodeHelper.getReference("sys_user", "email", remoteEmail)?.sys_id }
You can replace the following parameters:
Name of the table.
Name of the table column.

Example of getting a reference id by using a Jira custom field:

//Incoming script //Receiving a value from a Jira Custom Field where the CF name is "Jira Custom Field name" def remoteAssignmentGroup = replica.customFields."Jira Custom Field name"?.value incident."assignment_group" = nodeHelper.getReference("assignment_group", "name", remoteAssignmentGroup)?.sys_id

Sours: https://docs.idalko.com/exalate/display/ED/How+to+Send+and+Update+Reference+Fields+in+ServiceNow
  1. Ui goku dokkan
  2. Jiangshi powers
  3. Thursday morning quotes
  4. Naruto group chat

Display values

Reference fields store a sys_id for each referenced record in the database, but the sys_id is not shown.

The reference field shows the display value. For example, an incident's Assigned to field stores the sys_id of a particular user, but actually displays the user's name. The following example shows how Charlie Witherspoon, which is the display value of a user record, is shown in the Assigned to field.

Reference fieldValue stored in databaseDisplay value field of source tableValue displayed in UI
Assigned to [task.assigned_to]46b87022a9fe198101a78787e40d7547Name [sys_user.name]Charlie Whitherspoon
Reference fields show display values in:
Sours: https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/field-administration/concept/c_DisplayValues.html

.

Value servicenow display reference field

.

.

Similar news:

.



680 681 682 683 684