How to fetch approver and comments when notification table is Knowledge

[Winnie P]

Hello all, I have seen a few posts relating to my query but have not found an answer that works.

My notification is on the knowledge table. When the approver rejects a kb article, the notification is not showing the approver name or approver comments - it is blank.  How can I fetch these details to display it on the notification.  What is best method please? Is creating email scripts the only way? Will I need 2 emails scripts, 1 for comments and 1 for approver?

Our approval process for KB articles have 2 approver levels:

Approver 1 = Peer Reviewer
Approver 2 = Knowledge Manager

Our current notification is set up as follows:

Thank you.

[Tony Chatfield1 · Accepted solution]

Hi, the relationship between a knowledge article and it's approvals is a 1 to many relationship, and so there is no direct mapping to the approval record.
if you want to include the 'approval' record details in your notification then you could trigger your notification from sysapproval_approver and then dot.walk back to your KB record.
The other option would be to use a notification email script to query sysapproval_approver for the approval record, but running the notification on sysapproval_approver would be the cleanest solution.

[Winnie P]

Appreciate your reply Tony. When using the sysApproval table - we couldn't dot walk to send the reject notification to the Author. We changed the table to Knowledge, which now works except it's not able to fetch the comments/approver details to add to the notification?  But sounds like an email script might do the trick? Do you have any email script samples to share to fetch comments/approver details? Regards.

[Winnie P]

Hello Tony, We changed the target table back to sysapproval_approver and made it work by amending the Event in our Knowledge workflow. We didn't need the email scripts. Thank you.

[Sakhir]

Hello Winnie , Can you please guide me How you did that I am having same issue looking to sort it the way you have done. Any help will be appreciated.