How can we identify if a user's notification preferences have changed?

Products

• Clarity PPM SaaS

Issue/Introduction

How can we identify if a user's notification preferences have changed?

Environment

Release : SAAS

Component : CA PPM SAAS BUSINESS PROCESS MANAGEMENT

Resolution

select clb_notification_prefs.last_updated_date,clb_notification_prefs.last_updated_by,
clb_notification_prefs.user_id,clb_notification_prefs.notification_type,
CMN_SEC_USERS.user_name
from clb_notification_prefs
left outer join CMN_SEC_USERS
on clb_notification_prefs.user_id = CMN_SEC_USERS.id
order by clb_notification_prefs.last_updated_date desc;