How to give HR Cases to the approvers

[Munny1]

Hi Team,

As we have restricting the HR cases . We have written a query business rule to have access to the HR cases for submitted by and Assignment group . But the issue is even the approvals not able to see the data but he should have access to the case.

How can we achieve that approver  should we have access?

[Sandeep Rajput]

@Munny1 In your query business rule, you need to do apply following code.

var glideApprover = new GlideRecord('sysapproval_approver_list');
glideApprover.addQuery('approver',gs.getUserID());
glideApprover.addQuery('state','requested');
glideApprover.query();
var sysIDArray=[];
while(glideApprover.nex()){
   sysIDArray.push(glideApprover.getValue('document_id'));
}

if(sysIDArray.length>0){
    current.addQuery('sys_id', 'NOT IN', sysIDArray.join());
}

[Munny1]

Hi @Sandeep Rajput ,

Thank you reply

[Sandeep Rajput]

Here is the BR you should try.

var glideApprover = new GlideRecord('sysapproval_approver_list');
glideApprover.addQuery('approver',gs.getUserID());
glideApprover.addQuery('state','requested');
glideApprover.query();
var sysIDArray=[];
while(glideApprover.nex()){
   sysIDArray.push(glideApprover.getValue('document_id'));
}

if(sysIDArray.length>0){
    current.addEncodedQuery('opened_byDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^ORsys_idIN'+sysIDArray.toString());
}
else{
current.addEncodedQuery('opened_forDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^ORopened_byDYNAMIC90d1921e5f510100a9ad2572f2b477fe');
}

Hope this helps.