In email notification, the dot walking is not working

Kannan Nair · ‎05-22-2017

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

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

Is there any limitation on dot walking the field?

Chuck Tomasi · ‎05-23-2017

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.

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.

View solution in original post

Chuck Tomasi · ‎05-24-2017

Glad you got it working.

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.

Thank you

Pradeep Sharma · ‎05-22-2017

Hello Sanker,

I don't think there is any limitation as such. Is the notification working fine when you remove the condition filter(for testing purpose)?

Ivano B · ‎05-22-2017

Hi Sanker

Quick question. Are you sure on sys_user table you have the roles field populated ?

I know that the field is there but no one is using it.

I think this is the reason why your email is not triggered

The user's roles are on a m2m table named sys_user_has_role.

I hope this will help/answer you're question and if it does please marke it

Cheers

R0b0