Skip to main content

Hi Experts,

 

I am trying to create a custom Substitution map for my distribution list. The notifications are not being sent to the email. Just want to confirm with you guys that Sub map setup is correct.

Background:
I am creating a notification for updates to PERSON_SKILL table.

  1. VIEW table select statement is running a DATEDIFF function
  2. Scheduled Process is periodically pulling inputs from VIEW table and updating to PERSON_SKILL.USER_DEF3
  3. An Update is sent to PERSON_SKILL.USER_DEF3 from Scheduled Process
  4. Notification BR runs
  5. Email is sent to wild card members

I have tested all steps and step 5 works for Mobile Notifications by hardcoding PERSON_ID, I am having trouble with custom sub map if i use below wildcards for both Mobile and email notification. So issue is most probably due to Sub map / distri. List.

 

List of Wild Card Members:
1. Team Lead of a team: TEAM.PERSON_ID_LEADER

 

 

2. Person of the corresponding PERSON_SKILL line that was updated

 

Appreciate your help. 

 

 

Hi @StejonatL 

Not sure if this is correct or not, but would the TEAM.PERSON_ID_LEADER map benefit from adding in a constraint? 

Ady


Reply