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.
- VIEW table select statement is running a DATEDIFF function
- Scheduled Process is periodically pulling inputs from VIEW table and updating to PERSON_SKILL.USER_DEF3
- An Update is sent to PERSON_SKILL.USER_DEF3 from Scheduled Process
- Notification BR runs
- 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.
