I am trying to return all approvals for a specific Catalog Item, i have the script working but i want to run when you select on a module in the navigation.
Here is my script:
var approvalTest = Class.create();
approvalTest.prototype = Object.extendsObject(AbstractAjaxProcessor, {
populateApprovals: function() {
var approvals = [];
var grApprovals = new GlideRecord('sysapproval_approver');
grApprovals.addQuery('state', 'requested');
grApprovals.query();
while (grApprovals.next()) {
var grRitm = new GlideRecord('sc_req_item');
grRitm.addQuery('active', true);
grRitm.addQuery('sys_id', grApprovals.sysapproval);
grRitm.query();
if (grRitm.next()) {
approvals.push(grApprovals.getUniqueValue());
}
}
return approvals.join(',');
},
type: 'approvalTest'
});
here is the filter but it returns null , is there a way to run javascript via a filter,
here is the module setup:
Check the sys_property glide.script.use.sandbox on your instance, you need to make the SI either client callable or sandbox enabled for the script to work in a list filter.
Also you are doing nested queries in your script, for every row of approvals your script does a query for a matching ritm. Here are two alternative ways to achieve your result in a more performant way. Either adding a join sub query or by adding dot walked conditions.
var approvalSysids = []
var itemApprovalGr = new GlideRecord("sysapproval_approver");
itemApprovalGr.addQuery("state", "requested");
itemApprovalGr.addJoinQuery("sc_req_item", "sysapproval", "sys_id")
.addCondition("active", true)
//.addCondition("cat_item", [item sysid]);
itemApprovalGr.query()
while (itemApprovalGr.next()) {
approvalSysids.push(itemApprovalGr.getUniqueValue())
}var approvalSysids = []
var itemApprovalGr = new GlideRecord("sysapproval_approver");
itemApprovalGr.addQuery("state", "requested")
.addCondition("sysapproval.sys_class_name", "sc_req_item")
.addCondition("sysapproval.active", true)
//.addCondition(""sysapproval.ref_sc_req_item.cat_item"", [item sysid]);
itemApprovalGr.query()
while (itemApprovalGr.next()) {
approvalSysids.push(itemApprovalGr.getUniqueValue())
}
Note the significantly lower sql count and response time that can be achieved using above logic instead.
