Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

update additional comments with approvals

Community Alums
Not applicable

Hi,

I am trying to add the approval history of ritm to ritm additional comments. Once approval is requested all requested state approvers should be added in a single additional comment. For this i have written a BR on sysapproval_approver table and written the below code. When gliding the sysapproval_approver and querying sysapproval the value of sysapproval is coming as undefined.

 

 
1 REPLY 1

JenniferRah
Mega Sage
Mega Sage

Your code is missing an opening parentheses before the start, but I'm assuming that's a copy/paste issue. 

 

Your gs.info line is trying to print out approvalGR.sysapproval before approvalGR is assigned. 

 

When I run the same code in my PDI, removing your gs.info line inside the if (approvalGR.next()) loop, it shows me the value of sysapproval.