Skip to main content
Question

How to create a substitute maps: Wildcard used for resolving substitution variables in notification messages

  • January 22, 2024
  • 3 replies
  • 64 views

buddhima
Sidekick (Employee)
Forum|alt.badge.img+6

Hi experts, 

I need to add the request.access_group variable in a notification message which is sent when an escalation is created. So, I have thought of starting from the escalation table, then moving to quote table and then moving to request table, and from there getting the access group value. 

In my notification message, I have included {{request.access_group}}.

This is the Substitution map I have created which is giving an empty value in the email.

How can I get this to work?

 

Cheers,

Buddhima

3 replies

AdrianEgley
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • January 22, 2024

@buddhima 

On the screen grab, I think you need to switch the Related Table and Primary Col Name. Not sure if that will fix it, but those two appear to be the incorrect way round.

Ady


Forum|alt.badge.img+8
  • Sidekick (Customer)
  • January 23, 2024

Misread your question so I’m editing my comment. I believe Adrian is correct.

Sorry about that.


Forum|alt.badge.img+10
  • Hero (Employee)
  • July 9, 2024

@buddhima 

Hi just in case to be more specific the issue is on the second line you have request_id as the related table and request for the primary col name.

 

Cheers

Morris