update additional comments with approvals
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2024 09:45 AM - edited 11-26-2024 06:14 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2024 12:21 PM
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.