Append Employee Hire Date

[preethigovi]

Hi Team,

I need to append employee Hire date to Journey table title field. I need to do this for 1500 plus users.

That is like: Digital Onboarding - NETHERLANDS CornMine AMP Last name - 2024-02-14

I wrote fix script to pass the employee ids from journey table

var jnyMem = [];

var mapped_id = [];

var associatedDate;

var journeyGR = new GlideRecord('sn_jny_journey');

journeyGR.addEncodedQuery('numberINJNY00000949,JNY00000369,JNY00000365');

journeyGR.query();

while (journeyGR.next()) {

    jnyMem.push(journeyGR.getValue('employee'));

}

gs.info('Preethijny1 ' + JSON.stringify(jnyMem))

var hr_include = new sn_hr_core.getHiredate().getHrDate(jnyMem);

gs.info('Preethijny4 ' + JSON.stringify(hr_include));

var empMmber = new GlideRecord('sn_jny_journey');

empMmber.addEncodedQuery('numberINJNY00000949,JNY00000369,JNY00000365');

//empMmber.addQuery('employee', 'IN', Object.keys(hr_include).join(','));

empMmber.query();

while (empMmber.next()) {

    var emp_id = empMmber.getValue('employee');

    for(var i=0;i<jnyMem.length;i++){

    //associatedHireDate = hr_include[emp_id];

    var a= jnyMem[i]=hr_include[i];

    empMmber.title += ' ' + '-' + a;

    gs.info('preethi7 ' + empMmber.title);

}

gs.info('preethi7 ' + empMmber.title);

gs.info('preethi8 ' + emp_id);

Please help to correct

[preethigovi]

Thank You @Abhay Kumar1   It worked. Thanks much

I have to run this fix script for data correction in prod so i don't want to sent any notification to journey employees.

does set workflow(false) helps to restrict?

How i can take that preventive action.