doubt

Bruce lee
Tera Contributor

‎07-26-2023 12:28 AM

 

 

(function executeRule(current, previous /*, g*/ ) {
    var userGR = new GlideRecord('sys_user');
    userGR.addQuery('u_dob','ISNOTEMPTY');
    userGR.query();
    while (userGR.next()) {
        var dobValue = userGR.getValue('u_dob');
        var currentYear = new Date().getFullYear();
        var dobDate = new Date(dobValue);
        dobDate.setFullYear(currentYear);
        var newDOB2 =(dobDate.getFullYear() + '-' + ('0' + (dobDate.getMonth() + 1)).slice(-2) + '-' + ('0' + dobDate.getDate()).slice(-2));
        current.u_dob2 = newDOB2;
        current.update();
    }
})(current, previous);

 

 

0 Helpfuls
  • 164 Views
1 REPLY 1

Karan Chhabra6
Mega Sage
Mega Sage

‎07-26-2023 12:39 AM

Hi @Bruce lee ,

 

Replace addQuery() with addEncodedQuery() and remove the current.update() and check again, please refer to the code below:

(function executeRule(current, previous /*, g*/ ) {
    var userGR = new GlideRecord('sys_user');
    userGR.addEncodedQuery('u_dobISNOTEMPTY');
    userGR.query();
    while (userGR.next()) {
        var dobValue = userGR.getValue('u_dob');
        var currentYear = new Date().getFullYear();
        var dobDate = new Date(dobValue);
        dobDate.setFullYear(currentYear);
        var newDOB2 =(dobDate.getFullYear() + '-' + ('0' + (dobDate.getMonth() + 1)).slice(-2) + '-' + ('0' + dobDate.getDate()).slice(-2));
        current.u_dob2 = newDOB2;
    }
})(current, previous);

 

If my answer has helped with your question, please mark it as correct and helpful

 

Thanks!

0 Helpfuls