Bryan,
Here are the script pieces:
3. Added a business rule to sc_request that triggers on Insert, this rule checks all the child sc_req_item records for u_manager_approval_required and if it exists sets the same field to true at the sc_request level.
Business Rule Name: Calculate Manager approval
Table: Request [sc_request]
When: Before, on Insert
Script:
function onBefore(current, previous) {
var item = new GlideRecord('sc_req_item');
item.addQuery('request', current.sys_id);
item.query();
while(item.next()){
if(item.cat_item.u_manager_approval_required){
current.u_manager_approval_required = true;
break;
}
}
}
4. Modified the workflow to add a script that checks if the field is set to true and if it is checks if either the opened_by or requested_for is a manager in which case the sc_request is set to approved otherwise an approval is generated to requested_for.manager. If the field is false then the sc_request is approved.
Here is a screenshot of our simple Service Catalog Request workflow as it stands now. The first IF contains the script below.
For the script portion you have to find a way to determine if the requested_for or opened_by is a manger in your organization. This could be a user attribute, whether they have reports or not or their title. An example with the title is below.
answer = ifScript();
function ifScript(){
// if the request has an item that requires manager level approval...
if(current.u_manager_approval_required == true){
// if the requested_for or opened_by is a manager then manager approval has been met
if(current.requested_for.title.toLowerCase().indexOf('manager') != -1 || current.opened_by.title.toLowerCase().indexOf('manager') != -1){
return 'no';
} else {
return 'yes';
}
} else{
return 'no';
}
}
