Email Notification to the Group Email

ElvinSalim
Tera Contributor

This is the email script I'm trying to send an email notification to the group emails, but it doesn't seem to work. What have I missed?

ElvinSalim_1-1697544861926.png

 

ElvinSalim_2-1697544914109.png

 

 

8 REPLIES 8

AnveshKumar M
Tera Sage
Tera Sage

Hi @ElvinSalim 

 

You are querying sys_user table and querying on group_emails field. I don't think the sys_user table will contain that field.

 

What event.param1 will contain?

 

Can you please elaborate your requirement and what you are trying to achieve?

Thanks,
Anvesh

@AnveshKumar M 

sys_user table is actually sys_user_group table, I just modified it, and the group_emails is the red-colored field in the picture. What I am trying to achieve is to send email notification to these 2 emails which are red- colored in the picture

ssbild.png

Alka_Chaudhary
Mega Sage
Mega Sage

Hello @ElvinSalim,

 

Group email field is not present in user table. You should Glide 'sys_user_group' table. But to understand it better please provide this information:-  "What value you are getting in event parm1?"

 

Thanks,

Alka

@Alka_Chaudhary 

yes, its actually 'sys_user_group' table. I am a bit unsure about event.param1, I got it from an email script that also triggers same table with group members