- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 08:37 AM
Hello,
I have written below code to update my approval status and rejection comments on approval table. My state is updated but I am facing issue in updating value in comment field. It is Journal input field.
var approval = new GlideRecord('sysapproval_approver');
approval.addQuery('sysapproval',number);
approval.addQuery('approver',userID);
approval.query();
while(approval.next()){
approval.comment = comments;
approval.state = 'rejected';
approval.updateWithReferences();
}
Thanks you in advance. Help is really appreciated.
Regards,
Vaibhav Desai
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 09:16 AM
You know what, your field name is incorrect here. It should be comments and also use update here. You do not need updateWithReferences()
var comments = this.getParameter('sysparm_comments');
var number = this.getParameter('sysparm_number');
var userID = this.getParameter('sysparm_userID');
gs.log(">>>>>>>>>>>>COMMENTS "+comments+" NUMBER "+number+" USER ID "+userID);
var approval = new GlideRecord('sysapproval_approver');
approval.addQuery('sysapproval',number);
approval.addQuery('approver',userID);
approval.query();
while(approval.next()){
approval.comments = comments;
approval.state = 'rejected';
approval.update();
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 09:16 AM
You know what, your field name is incorrect here. It should be comments and also use update here. You do not need updateWithReferences()
var comments = this.getParameter('sysparm_comments');
var number = this.getParameter('sysparm_number');
var userID = this.getParameter('sysparm_userID');
gs.log(">>>>>>>>>>>>COMMENTS "+comments+" NUMBER "+number+" USER ID "+userID);
var approval = new GlideRecord('sysapproval_approver');
approval.addQuery('sysapproval',number);
approval.addQuery('approver',userID);
approval.query();
while(approval.next()){
approval.comments = comments;
approval.state = 'rejected';
approval.update();
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 09:20 AM
Hey abhinay,
Really thanks. Can't understand how i missed it. Thanks again.
Regards,
Vaibhav Desai

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 09:22 AM
Not a problem. It happens with everyone.