I'm working on catalog items. I have fields that are being populated when I'm logged in as admin and are not being populated when I'm not. I figure it's an ACL issue. I look through the ACLs for the sys_user table and can't seem to find what's preventing non-admin users from reading from the table.
Does this access control not allow for everyone to read from the table?
Context:
I have a catalog item that has several fields that are populated with an onLoad catalog client script.
Catalog client script:
// Function that triggers when the ServiceNow form loads.
function onLoad() {
// Check if the user ID is undefined.
if (!g_user.userID) {
// Show an alert if the user ID is undefined.
alert('User ID is undefined');
return;
}
// Initialize a GlideAjax object to fetch user details.
var glideAjax = new GlideAjax('PopulateCatalogDefaults');
// Add parameters to the GlideAjax object.
glideAjax.addParam('sysparm_name', 'getUserDetails');
glideAjax.addParam('sysparm_userID', g_user.userID);
// Execute the GlideAjax call and use populateFields function as the callback.
glideAjax.getXML(populateFields);
}
// Callback function to populate the form fields based on the GlideAjax response.
function populateFields(response) {
// Parse the XML response to get the "answer" attribute.
var answer = response.responseXML.documentElement.getAttribute("answer");
// Convert the "answer" attribute to a JavaScript object.
var userObj = JSON.parse(answer);
// Populate the 'users_person_number' field with the user's sys ID.
g_form.clearValue('users_person_number');
g_form.setValue('users_person_number', userObj.userSysId);
}
Here is the script include that's being called:
// Declare a new class called PopulateCatalogDefaults.
var PopulateCatalogDefaults = Class.create();
// Extend the PopulateCatalogDefaults class from AbstractAjaxProcessor.
PopulateCatalogDefaults.prototype = Object.extendsObject(AbstractAjaxProcessor, {
// Define a method called getUserDetails.
getUserDetails: function(userID) {
// Create an empty object to store user information.
var userInfo = {};
// Initialize a GlideRecord object for the 'sys_user' table.
var userGR = new GlideRecord('sys_user');
// Get the user ID from the incoming parameter.
var g_userId = this.getParameter('sysparm_userID');
// Query the 'sys_user' table for the given user ID.
if (userGR.get(g_userId)) {
// Populate the userInfo object with the user's unique sys ID.
userInfo.userSysId = userGR.getUniqueValue();
}
// Return the userInfo object as a JSON-formatted string.
return JSON.stringify(userInfo);
},
// Specify the type of the class as 'PopulateCatalogDefaults'.
type: 'PopulateCatalogDefaults'
});
Are you referring to the "user query" Business Rule? Setting it to inactive did not solve my problem, unfortunately.
