@Snow-Man I am assuming, you would like to populate the Executive Assistance field which is available on the HR Profile record of the logged in user as a Requested for.
If this assumption is correct and if there are no other dependent questions then I recommend you to use a combination of GlideAjax and a server side script include to fetch the value for Requested/Opened for field.
Here is an example of the onLoad script for your record producer.
Please create the client script in sn_hr_core_scope.
// Client Script - onLoad
function onLoad() {
// Get the user ID of the logged-in user
var userID = g_user.userID;
// Create a new GlideAjax object, calling the server-side script include 'GetExecutiveAssistant'
var ga = new GlideAjax('sn_hr_core.GetExecutiveAssistant');
// Add the user ID as a parameter
ga.addParam('sysparm_sys_id', userID);
// Make the asynchronous call to the Script Include
ga.getXMLAnswer(function(response) {
var executiveAssistantSysId = response.responseXML.documentElement.getAttribute("answer");
if (executiveAssistantSysId) {
console.log('Executive Assistant Sys ID: ' + executiveAssistantSysId);
// You can perform additional actions with the sys_id here, like populating fields
g_form.setValue('requested_for',executiveAssistantSysId);
} else {
console.log('No Executive Assistant found for the logged-in user.');
}
});
}
Script Include: Make sure to create the script include in sn_hr_core scope.
// Script Include - GetExecutiveAssistant
var GetExecutiveAssistant = Class.create();
GetExecutiveAssistant.prototype = Object.extendsObject(AbstractAjaxProcessor, {
// This method will be called by the client-side GlideAjax call
getExecutiveAssistant: function() {
// Get the user sys_id from the client script
var userSysId = this.getParameter('sysparm_sys_id');
// Query the HR Profile table (sn_hr_core_profile) to find the Executive Assistant for this user
var hrProfileGR = new GlideRecord('sn_hr_core_profile');
hrProfileGR.addQuery('user', userSysId); // Assuming 'user' is the reference to the logged-in user
hrProfileGR.query();
if (hrProfileGR.next()) {
// Check if the 'Executive Assistant' field is populated
if (!gs.nil(hrProfileGR.u_executive_assistant)) { //Update the field name which reflects your field.
return hrProfileGR.u_executive_assistant.toString(); // Return the sys_id of the Executive Assistant
}
}
// If no record found or no Executive Assistant, return an empty string
return '';
}
});
