How we can write the Notification Content in What it will contain section for multiple records

Amrutha K V
Tera Contributor

‎09-27-2023 05:35 AM - edited ‎09-27-2023 05:43 AM

Hi Team,

In Knowledge base table, suppose if inactive owner having multiple knowledge base records(Email,Knowledge,IT) and in all these records if kb_managers field is empty , then we have to send one notification to a particular DL (ABCD@servicenow.com) that owner is terminated for all these knowledge base records: Email,Knowledge,IT. 


Could you please help me how I can bring these records together "Email,Knowledge,IT." in notification content. 
Please help me with the email content in 'What it will contain' section of Notification table.

Eg : Notification content:

Hi All,

The Owner: TestUser1 of the Knowledge Base :Email,Knowledge,IT is terminated. 
Please take an action to update the same.
Thank you!


I tried in this manner, but I am getting only one knowledge base record. I need multiple records:Email,Knowledge,IT which is based on that inactive owner in this notification. 
Please help me with the notification content.

AmruthaKV_0-1695817866995.png

 


Thank you!

0 Helpfuls
  • 194 Views
1 REPLY 1

Saurav11
Kilo Patron
Kilo Patron

‎09-27-2023 06:15 AM

Hello,

 

Yu will need to query all the records and then send one email with all the information. You can do this is a email script.

 

You can refer the below for the same:-

 

https://www.servicenow.com/community/developer-forum/query-for-all-records-assigned-to-a-user-but-se...

 

Please mark my answer as correct based on impact

0 Helpfuls