I’ve created a Relationship under the Catalog Task [sc_task] table to display related notifications. This works for most notifications linked to a Catalog Task, but it does not show the out-of-the-box @mention notifications.
I can see those @mention notifications being logged, and I know they are created in the live_notification table, but they don’t appear in my current relationship.
Is there a way to build a relationship that also pulls in these @mention notifications from live_notification so they show up alongside the other task-related notifications?
Hi Akash,
The behavior you’re seeing is because your current relationship is querying the Email [sys_email] table, which holds most task-related notifications. However, the out-of-the-box @mention notifications are stored separately in the Notification [live_notification] table.
To include those @mention notifications alongside your other notifications, I recommend creating a separate relationship on the Catalog Task [sc_task] table that queries the Notification [live_notification] table directly. You can use the following script in the relationship’s query to ensure it pulls the relevant notifications linked to the Catalog Task:
(function refineQuery(current, parent) {
current.addQuery("table", parent.sys_class_name);
current.addQuery("document", parent.sys_id);
})(current, parent);
This script filters the live_notification records by matching the task’s table name and sys_id, effectively linking the @mention notifications to the task.
Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.
