Clarity

 View Only
  • 1.  Notifications under Organizer

    Posted Sep 26, 2020 11:20 AM

    From the Admin account side - I see some records under Notifications. 

    Examples

    If a resource is added to Project/Task - he receives email.

    Some custom process will triggers emails to users on Timesheet failures

    A user is usually assigned to Action items, to complete them

    So are the above examples will be seen under this Notifications section?

    I tried to join the Table but not able to get below view in terms of Query - Please correct it.

    /* Half completed Query */

    SELECT
    notif.*
    FROM clb_notifications notif
    JOIN clb_notification_prefs pref ON pref.user_id = notif.receiver_id
    WHERE pref.notification_type='NOTIFICATION_CHANGES'
    and notif.event_type='NOTIFICATION_RISKS'



  • 2.  RE: Notifications under Organizer

    Posted Sep 26, 2020 02:16 PM

    There are ERD*s for Action items and Notifications in the documentation. That could help a little, but they do not link action items to notifications.

    The link could be through processes (BPM_RUN_STEPS)