we have to use Test1 service ID number in to other two hr service requests

vijani
Tera Expert

when ever raising Test1 Hr service case it will  generate one ID number  and this generated ID number we are populating in another two hr service requests (Test2 HR service, Test3 HR service).

if we use ID number in Test2 HR service then it should not be use again in same Test2 HR service  and should not shown to Test3 HR service also.

similarly if we use ID number in Test3 HR service then it should not be use again in same Test3 HR service and should not shown to Test2 HR service also.

 

we are not getting ID number in Test2 HR service which has been used in Test3 HR service, and vice versa  and it is working fine.

 

but the used ID number  is again showing in Test2 HR service which was previously used in same Test2 HR service

 

 

 

requestnumberTEST2function(sysIDofOpenedFor) { 
        var arr = [];
var hrRec = new GlideRecord('sn_hr_core_case');
          hrRec.addEncodedQuery('hr_service=c80cc9e81b6f89100b9a11739b12t4e6^state=3^approval=approved^opened_for=' + sysIDofOpenedFor);
        hrRec.query();
        while (hrRec.next()) {
            var hrRec1 = new GlideRecord('sn_hr_core_case');
            hrRec1.addEncodedQuery('hr_service=541d89391b6b05100b8b11739b4bcae8');
            hrRec1.addQuery('u_id_number', hrRec.u_id_number);
            hrRec1.addQuery('state'"IN"'1,10,11,18,3,4');
            hrRec1.query();
            if (!hrRec1.next()) {

                arr.push(hrRec.sys_id.toString()); 
            }
        }
        return 'sys_idIN' + arr.join();
    },
 
 

    requestnumberTEST3function(sysIDofOpenedFor) { 
        var arr = [];
        var hrRec = new GlideRecord('sn_hr_core_case');
        hrRec.addEncodedQuery('hr_service=c80cc9e81b6f89100b9a11739b12t4e6^state=3^approval=approved^opened_for=' + sysIDofOpenedFor);
        hrRec.query();
        while (hrRec.next()) {

            var hrRec1 = new GlideRecord('sn_hr_core_case');
            hrRec1.addEncodedQuery('hr_service=2e1325cd1be741100b9a11739b42a346');
            hrRec1.addQuery('u_id_number', hrRec.u_id_number);
            hrRec1.addQuery('state'"IN"'1,10,11,18,3,4');
            hrRec1.query();

            if (!hrRec1.next()) {
               arr.push(hrRec.sys_id.toString()); 
              
            }

        }

       return 'sys_idIN' + arr.join();
    },

 

0 REPLIES 0