How to enter value in "Journal Input" type field using server side script?

[vaibhavdesai]

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

[BALAJI40]

approval.comment = 'place comments here'// if you place comments line in '' this also its not updated?

[BALAJI40]

Hi Vaibhav,

try with this,

var approval = new GlideRecord('sysapproval_approver');

  approval.addQuery('sysapproval',number);

  approval.addQuery('approver',userID);

  approval.query();

  while(approval.next()){

  approval.comment = 'comments';   // give dots

  approval.state = 'rejected';

  approval.update(); // This one is enough, update reference will be used for reference fields

  }

[Abhinay Erra]

Can you post the entire script?

[vaibhavdesai]

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.comment = comments;

  approval.state = 'rejected';

  approval.updateWithReferences();

  }

[vaibhavdesai]

In log I am reeving all values. Not, Sure what is the issue. State is updated everytime. But, I guess because of journal field I am not able to write anything. As it is audited.