Notifications Settings/Preferences

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Is there a way to determine which users are receiving notifications?

In reviewing the Administration > Data Administration > Notifications 

This has been Saved and Published.

The discrepancy is that although all are cleared, the notifications are still being sent.

For example, if a user goes to their Home > Personal > Account Settings > Notifications page,
and has only item 15 checkmarked the method 'Alert' and 'Email', there should only be 2 records inserted into the table: CLB_NOTIFICATION_PREFS for the user.

1. Action Items   
2. Change Requests   
3. Conversations   
4. Discussions   
5. Documents   
6. Escalations   
7. Finance   
8. Incidents   
9. Issues   
10. Processes   
11. Projects   
12. Reports and Jobs   
13. Requisitions   
14. Risks   
15. Timesheets

However when running basis query:

SELECT 
user_id, NOTIFICATION_TYPE, METHOD, status
FROM CLB_NOTIFICATION_PREFS

It shows 100+ records instead of one of the 15 records.

 

 

Environment

Release : All

 

Cause

 

 

Resolution

This working as designed.
Although the objects are checkmarked, until the enduser clicks save, the CLB_NOTIFICATION_PREFS will not be updated.

The following updated query can confirm which users are receiving notifications of a certain type:

SELECT 
user_id, NOTIFICATION_TYPE, METHOD, status
FROM CLB_NOTIFICATION_PREFS
where status = 1