Rejection Comments in email not appearing

[Troy S_]

I have the following <mail_script>in my Workflow Notification:

<mail_script>  

  //get the related approvals for this change  

  //check for any reject and display comments  

  //create a new glide record query for approval records  

  var appr = new GlideRecord('sysapproval_approver');  

  //get approvals for this change  

  appr.addQuery('sysapproval',current.sys_id);  

  //get rejected approvals  

  appr.addQuery('state','rejected');  

  //execute the query  

  appr.query();  

  //process each result if there are any  

  if (appr.next()) {  

      //print the approval info to the email message  

      template.print('Approver: ' + appr.approver.getDisplayValue() + '\n');  

      template.print('State: ' + appr.state) + '\n';  

      template.print('Comments: ' + appr.comments + '\n');

      template.print('\n');  

  }  

</mail_script

It is returning the following:

       

The field I am pulling in from is:

       

Thank you in advance for your help on this issue.

Troy

[reginabautista]

You need to loop thorugh the records..try changing code below

FROM

if (appr.next()) {

TO

while (appr.next()) {

[Troy S_]

I changed it to

        while (appr.next()) {

However it still returned the same response that I got above.

       

[ankit_sharma487]

try with changing if (appr.next()) to While (appr.next()). it will execute till you have matching records and IF will do for once only

[Troy S_]

That did not work, same results