Hi @Sofvrg ,
A reference field is a field type in ServiceNow that links a record from one table to a record in another table, creating a relationship between the two. It stores the sys_id of the referenced record and allows you to access related information through dot-walking.
1. Creates Relationships: Links tables, enabling one table to reference data from another.
2. Stores Sys_ID: Stores a unique identifier of the referenced record.
3. Allows Dot-Walking: Access fields of the referenced table directly.
4. Common Use: Simplifies data relationships and avoids duplication.
Example: Incident’s caller_id Field
The caller_id field in the Incident table is a reference to the sys_user table.
It lets you select a user as the caller for an incident.
Accessing Referenced Fields:
current.caller_id.name: Retrieves the name of the caller.
current.caller_id.email: Retrieves the email of the caller.
Simple Example:
(function executeRule(current, previous /*null when async*/) {
// Get the caller's name and email
var callerName = current.caller_id.name;
var callerEmail = current.caller_id.email;
gs.log('Caller Name: ' + callerName);
gs.log('Caller Email: ' + callerEmail);
})(current, previous);
This script retrieves and logs the name and email of the caller from the sys_user table
Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand
