AnsweredAssumed Answered

send emails to supervisors

Question asked by Zoltan Izsak on Jul 5, 2018

use case: send email to affected users' supervisors in all email nodes (request wf, revert request, cancel request)


I wonder if there is a builtin variable for target users' supervisor id. Right clicking in sql select node I can pick user supervisor attribute but that is supervisor name. I have also tried with some modifications (${access_request_cri_meu_supervisorId}, ${access_request_cri_meu_supervisorID}, ${access_request_cri_meu_supervisor_id}, ${access_request_cri_meu_supervisor_Id}, ${access_request_cri_meu_supervisor_ID}), but none of them works.

I have tried the following solutions for use case as well:

In email node using object/user/supervisor for sending. It works except of cancel request workflow where it seems that no target user is defined.

In request workflow sql node I can use ${access_request_cri_meu_supervisorFullName} variable. However email "To:" part expects a user's database id, not full name.

I can use sql select for selecting user supervisor where user_id = ${access_request_cri_meu_userId}. It does not work properly when I have multiple target users, the sql will err in this case.


I can still use sql select for target user id array and next step node in case of multiple target users but it would be much easier to have a builtin variable like ${access_request_cri_meu_supervisor_id}


I am using 7.1.