In email notification, the dot walking is not working

Kannan Nair
Tera Contributor

I am trying to create a notification while there is an update on the attachment custom table,

Under when to send I am adding the condition

find_real_file.png

But the notification is not triggering even if the user has snc_internal role.

Is there any limitation on dot walking the field?

1 ACCEPTED SOLUTION

I suspect it's one of those situations where "role" on the user table is special and not behaving like a normal field.



In the Notification, click the Advanced view link.


find_real_file.png


and in the advanced condition field, create a script that checks if the user has a specific role by doing a GlideRecord query on sys_user_has_role. This box should return a true or false.



find_real_file.png


View solution in original post

7 REPLIES 7

Chuck Tomasi
Tera Patron

What table is this notification triggering on?



Have you tried "contains" (if it is available in the middle drop down)? It could be that roles has multiple values in it.


Contains option is not available, the notification is triggering on an custom table attachments, which extends from sys_attachment table, and in here a reference field case is available and which points towards the case table.



find_real_file.png


I suspect it's one of those situations where "role" on the user table is special and not behaving like a normal field.



In the Notification, click the Advanced view link.


find_real_file.png


and in the advanced condition field, create a script that checks if the user has a specific role by doing a GlideRecord query on sys_user_has_role. This box should return a true or false.



find_real_file.png


Thanks Chuck,



I have queried the role table and set answer=true, and now the notification is working fine.