using below script i need to update ritm closer comments

[mani55]

i am using below script to update closer comments in ritm but it's inserting the dummy record not updating record

 var grval = new GlideRecord('sc_req_item');
            grval.addQuery('sys_id','e03fae4b477eb6189c5e5cbd436d439e');
			grval.query();
            grval.close_notes = 'test';
            grval.update();

Any idea on this please let me know

[Ankur Bawiskar]

@mani55 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[mani55]

Hi Ankur,

i am using same script in widget level but still there is no luck script is not checking rejected directly going to sys_approval table

f (input.op == 'approved' || input.op == 'rejected') {
        gs.log("Your debug message here");
        if (input.reject_raison == 'true' && input.op == 'rejected') {
            var grreject = new GlideRecord('sc_item_option_mtom');
            grreject.addQuery('request_item', input.ritm_sys_id + '');
            // gs.log('the number' + grreject.request_item);
            grreject.addQuery('sc_item_option.item_option_new.name', 'reject_raison');
            grreject.setLimit(1);
            grreject.query();
            grreject.next();

            var grvalue = new GlideRecord('sc_item_option');
            grvalue.get(grreject.sc_item_option);
            grvalue.setValue('value', input.comments);
            grvalue.update();

            var grval = new GlideRecord('sc_req_item');
            if (grval.get('input.ritm_sys_id')) {
                grval.close_notes = input.comments;
                grval.update();
            }


        }
        var app = new GlideRecord("sysapproval_approver");
        if (app.get(input.target) && app.state.canWrite()) {
            gs.log("Your debug message here3");
            app.state = input.op;
            if (input.comments) {
                app.comments = input.comments;

            }
            app.update();
        }


    }