Knowledge base Feedback weekly notification

Mr-Pontus
Tera Contributor

Hi

 

I have a task to send a notification weekly, to the author of the Knowledge base article, with a overview of the articles that have received a comment. Can anyone please help me, on how I can achieve this?

 

Regards

7 REPLIES 7

@Mr-Pontus: Really glad to hear that.

And really nice question. I have personally not developed or implemented something similar, but I know for sure ServiceNow has a feature called Email Digest which does something similar as you are looking for.

You may need to explore more to find more details.

Hope this helps.

 

Kind Regards,

Swarnadeep Nandy

PWigham_AHEAD
Tera Contributor

Hey @Mr-Pontus ,
The way I'd likely go about this is to:
- Create an Event in the Registry that we can call and use to trigger a notification.
- Create a Notification that is sent when this Event is triggered.
- Create a Scheduled Job that looks at the kb_feedback table for any records created in the last week (you can even look at getting rid of duplicates in cases where the article received numerous comments). This will give us the articles that have been updated and then we can dot-walk to the Author of the article and pass that into the Event as a parameter which in turn is used as the sender in the notification:

PWigham_AHEAD_0-1692214081452.png
- You can then update the Notification content and, if needed, create a Notification Email Script to retrieve data from the records etc.

Hope the above makes sense and provides some ideas to move this forward for you.

 

Thanks,
PW

 

 

Thank you, yes I had the similar thought, but have some trouble with getting the email script to work