Email notification using m2m_kb_task table - group by task (INC##)

Keszia
Giga Guru

Hi all

I want to create an email notification that is triggered when an article in attached to an incident (m2m_kb_task), and have the email contain all the articles that were attached to that single task. This is the email notification I have created:

Keszia_0-1738200156076.png

I do not know how I can group all the articles into one email as the m2m_kb_task table adds each article separately. So not to spam the recipient with several emails when multiple article are attached to a single task, what conditions can I set to the email notification so that it is one email per task, regardless of how many articles are attached?

Keszia_1-1738200294829.png

 

15 REPLIES 15

Ankur Bawiskar
Tera Patron

@Keszia 

you can send daily schedule job and consolidate them at once

check this link where I shared solution and you can enhance it further. 1 email for all records in that day to that recipient.

Email script 

If my response helped please mark it correct and close the thread so that it benefits future readers.