Hi All,
I have a script Include which is fetching some values in the array and I want to pass those values in a Reference qualifier.
Here is my script. In the script there is a scratchpad variable I declared and I want that scratchpad to store the "impactedResourceID" and display it in the List Collector field via Reference qualifier.
var StrongDM_Catalog_Util = Class.create();
StrongDM_Catalog_Util.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
fetchUserResource: function() {
gs.info("inside fetchUserResource");
try {
var requestedFor = this.getParameter('sysparm_reqFor');
var user = new GlideRecord('sys_user');
user.addQuery('sys_id', requestedFor);
user.query();
if (user.next()) {
var userLookUpField = gs.getProperty('x_sdm_access_mgmt.user_lookup_attribute');
var lookUpValue = userLookUpField + ":" + user[userLookUpField];
gs.debug("Inside Get User Resources: User Lookup value is : " + lookUpValue);
var inputs = {};
inputs['user_lookup'] = lookUpValue;
inputs['requested_for'] = user;
var result = sn_fd.FlowAPI.getRunner().action('x_sdm_access_mgmt.SDM__get_catalog_api').inForeground().withInputs(inputs).run();
var outputs = result.getOutputs();
var resourceObj = new global.JSON().decode(outputs['response']);
gs.debug("Inside Get User Resources: ResponseBody: " + outputs['response']);
var impactedResourcesID = [];
impactedResourcesID = this.GetModifiedResources(lookUpValue, resourceObj);
gs.debug("Inside GetModifiedResources: Modified Resources are: " + impactedResourcesID);
//g_scratchpad.StrongDM_allowedResouceID = impactedResourcesID+""; // Need Help Here
var strongDM_RestUtil = new x_sdm_access_mgmt.StrongDm_RestAPI_Util();
var filter = strongDM_RestUtil.createResourceFilter(impactedResourcesID+"");
strongDM_RestUtil.fetchTags("", "", "");
strongDM_RestUtil.fetchResouces(filter, "", "");
}
} catch (ex) {
var message = ex.getMessage();
gs.error("Inside Get User Resources: Error " + message);
}
},
/*_________________________________________________________________
* Description: To Check if Resources metadata is modified or not
* Parameters: Array of Resocuces
* Returns: Modified Resources
________________________________________________________________*/
GetModifiedResources: function(lookUpValue, resourceObj) {
gs.info("inside GetModifiedResources");
var impatcedResource = [];
//Looping through resources
for (var i = 0; i < resourceObj['data'].length; i++) {
var ResourceID = resourceObj['data'][i]['id'];
var HashID = resourceObj['data'][i]['hash'];
var MaxDuration = resourceObj['data'][i]['maxDuration'];
var resourceId = this.findModifiedResourcesID(ResourceID, HashID);
if (resourceId)
impatcedResource.push(resourceId);
}
gs.debug("Inside GetModifiedResources:Total Resources modified are - " + impatcedResource);
return impatcedResource;
},
/*_________________________________________________________________
* Description: To compare Hash ID with ServiceNow resource table
* Parameters: ResourceID, HashID, impatcedResource (array)
* Returns:
________________________________________________________________*/
findModifiedResourcesID: function(ResourceID, HashID) {
gs.info("inside findModifiedResourcesID");
//Check if Hash ID is modified
var grResources = new GlideRecord("x_sdm_access_mgmt_resources");
grResources.addQuery("resource_id", ResourceID);
grResources.query();
if (grResources.next()) {
if (grResources.hash != HashID) {
gs.debug("Inside GetModifiedResources: Resource is modified: " + HashID);
return ResourceID;
}
return "";
} else {
return ResourceID;
}
},
type: 'StrongDM_Catalog_Util'
});
This is how the log just before the scratchpad is coming up:
Please help.
Hi,
I am little confused with your reply as I am not fetching the users rather trying to fetch the resources that I have stored in a custom table on the basis of the user being selected in the "Request for" field on the catalog item form:
Example: In the below catalog item, if Abel is selected, he will see only those resources in the slushbucket which he is authorized to and that I am fetching from the script include I wrote.
As you suggested, I tried to fetch the sys_id in the impactedResourceID and now trying to understand how to pass them into Reference Qualifier condition:
var StrongDM_Catalog_Util = Class.create();
StrongDM_Catalog_Util.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
fetchUserResource: function() {
gs.info("inside fetchUserResource");
try {
var requestedFor = this.getParameter('sysparm_reqFor');
var user = new GlideRecord('sys_user');
user.addQuery('sys_id', requestedFor);
user.query();
if (user.next()) {
var userLookUpField = gs.getProperty('x_sdm_access_mgmt.user_lookup_attribute');
var lookUpValue = userLookUpField + ":" + user[userLookUpField];
gs.debug("Inside Get User Resources: User Lookup value is : " + lookUpValue);
var inputs = {};
inputs['user_lookup'] = lookUpValue;
inputs['requested_for'] = user;
var result = sn_fd.FlowAPI.getRunner().action('x_sdm_access_mgmt.SDM__get_catalog_api').inForeground().withInputs(inputs).run();
var outputs = result.getOutputs();
var resourceObj = new global.JSON().decode(outputs['response']);
gs.debug("Inside Get User Resources: ResponseBody: " + outputs['response']);
var impactedResourcesID = [];
impactedResourcesID = this.GetModifiedResources(lookUpValue, resourceObj);
gs.debug("Inside GetModifiedResources: Modified Resources are: " + impactedResourcesID); // This log provides the sys_ids now.
// gs.getSession().putClientData('impactedResourcesID', JSON.stringify(impactedResourcesID));
//g_scratchpad.StrongDM_allowedResouceID = impactedResourcesID+"";
var strongDM_RestUtil = new x_sdm_access_mgmt.StrongDm_RestAPI_Util();
var filter = strongDM_RestUtil.createResourceFilter(impactedResourcesID+"");
strongDM_RestUtil.fetchTags("", "", "");
strongDM_RestUtil.fetchResouces(filter, "", "");
}
} catch (ex) {
var message = ex.getMessage();
gs.error("Inside Get User Resources: Error " + message);
}
},
/*_________________________________________________________________
* Description: To Check if Resources metadata is modified or not
* Parameters: Array of Resocuces
* Returns: Modified Resources
________________________________________________________________*/
GetModifiedResources: function(lookUpValue, resourceObj) {
gs.info("inside GetModifiedResources");
var impatcedResource = [];
//Looping through resources
for (var i = 0; i < resourceObj['data'].length; i++) {
var ResourceID = resourceObj['data'][i]['id'];
var HashID = resourceObj['data'][i]['hash'];
var MaxDuration = resourceObj['data'][i]['maxDuration'];
var resourceId = this.findModifiedResourcesID(ResourceID, HashID);
if (resourceId)
impatcedResource.push(resourceId);
}
gs.debug("Inside GetModifiedResources:Total Resources modified are - " + impatcedResource);
return impatcedResource;
},
/*_________________________________________________________________
* Description: To compare Hash ID with ServiceNow resource table
* Parameters: ResourceID, HashID, impatcedResource (array)
* Returns:
________________________________________________________________*/
findModifiedResourcesID: function(ResourceID, HashID) {
gs.info("inside findModifiedResourcesID");
//Check if Hash ID is modified
var grResources = new GlideRecord("x_sdm_access_mgmt_resources");
grResources.addQuery("resource_id", ResourceID);
grResources.query();
if (grResources.next()) {
if (grResources.hash != HashID) {
gs.debug("Inside GetModifiedResources: Resource is modified: " + HashID + " resources " + grResources.sys_id);
return grResources.sys_id; // Fetching the sys_id here.
}
return "";
} else {
return grResources.sys_id;
}
},
type: 'StrongDM_Catalog_Util'
});
Please suggest something.
