Notifications not received for external users that are setup in clarity

Products

• Clarity PPM SaaS

Issue/Introduction

Not all users for security group in clarity is getting job notifications. The user personal account settings for email notifications should ideally show job notifications checked (Home > account settings). How can notifications setting be set for external users and how to find if they are selected or not?

Environment

Clarity PPM 16.0.2

Resolution

Notification settings can only be set at a personal account setting level, the setting would be at an individual user level and for that the users would need to login to system. Clarity environment that are SSO enabled, users must either login via a federated user or non-federated (okta user), direct login is not possible. 

Create Okta users (non-federated) user for the external users and have the users login to setup notification settings. 

The following SQL query can be run against the clarity DB to check the accounts notification settings:

SELECT NOTIFICATION_TYPE, METHOD
                FROM CLB_NOTIFICATION_PREFS
                WHERE ((USER_ID = 5xxxxxx and PRINCIPAL_TYPE = 'USER' and STATUS = 0) or PRINCIPAL_TYPE = 'PUBLISH') and exists (select 1 from CLB_NOTIFICATION_PREFS where USER_ID = 5xxxxxx and PRINCIPAL_TYPE = 'USER') GROUP BY NOTIFICATION_TYPE,METHOD HAVING COUNT(*) = 1
                union all
        SELECT NOTIFICATION_TYPE, METHOD
                FROM CLB_NOTIFICATION_PREFS
                WHERE PRINCIPAL_TYPE = 'SAVE' and not exists (select 1 from CLB_NOTIFICATION_PREFS where USER_ID = 5xxxxxx and PRINCIPAL_TYPE = 'USER')

Note: 5xxxxxx would be the users internal id.