Hi Sabitha,
Here is what I would do:
- Add a true/false field to the Delegate table: Service request approvals [u_service_request_approvals]
- Add the following function to the getMyApprovals business rule:
function getMyServiceRequestApprovals(){
var u = gs.getUserID();
var answer = new Array();
var i = 0;
answer[i++] = new String(u);
var g = new GlideRecord("sys_user_delegate");
g.addQuery("delegate", u);
g.addQuery("u_service_request_approvals", "true");
g.addQuery("starts", "<=", gs.daysAgo(0));
g.addQuery("ends", ">=", gs.daysAgo(0));
g.query();
while( g.next())
answer[i++] = new String(g.user);
return answer;
};
3. Update the checkAllApprovers function from getMyApprovals business rule:
function checkAllApprovers(approver, table){ //Added a table parameter
if(JSUtil.nil(approver))
return false;
var apps = getMyApprovals();
//Add Service Request approvals if it is a Service Request
if(table == 'sc_request' || table == 'sc_req_item'){
var serviceRequestApps = getMyServiceRequestApprovals();
apps = apps.concat(serviceRequestApps);
}
for (key in apps) {
if (apps[key] == approver)
return true;
}
return false;
}
4. Update the isApprovalMine function from getMyApprovals business rule:
function isApprovalMine(gr) {
var approver = gr.approver + '';
// if this is the sysapproval_group table, gr.approver
// would evaluate to 'undefined'
if (!gr.isValidField('approver'))
approver = '';
var approverSysId = gr.sys_id + '';
// Check if approver is nil due to being on a list
// of records that contain a related list of approvers
// or due to checking a group approval
if(JSUtil.nil(approver) && JSUtil.notNil(approverSysId)) {
// Look at the sysapprover_approval table
var app = new GlideRecord('sysapproval_approver');
if (gr.getTableName() == 'sysapproval_group')
app.addQuery('group', approverSysId);
else
app.addQuery('sysapproval', approverSysId);
app.query();
while(app.next()) {
approver = app.approver;
if(checkAllApprovers(approver))
return true;
}
}
//Evaluating the table that the approval record is for
var table = '';
if(gr.source_table){
table = gr.source_table;
}
else if(gr.sysapproval){
table = gr.sysapproval.sys_class_name;
}
return checkAllApprovers(approver, table);
}
5. Update the My Approvals menus to add this new delegation
The filter should now look something like this:
I did not cover the notification system as it is kind of a separated thing because the delegation default setting is to delegate all emails, even the standard approvals delegation does not include emails.
The customization I propose include modification to OOTB script, so if done this way, skipped update should be reviewed on upgrade to make sure this customization still make sens with the OOTB script if it gets modified. If you don't plan on doing this review, you should probably, create a seperate business rules using different function names and then replacing the use of these functions in every module (menus), business rules, ACL, or other script that would need to take the Service Request delegation into account.
