Skip to main content
Question

Substitution Map

  • November 16, 2023
  • 1 reply
  • 40 views

Forum|alt.badge.img+7

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. 

 

 

1 reply

AdrianEgley
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • 170 replies
  • November 16, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings