Posts: 3
Threads: 2
Joined: Jan 2018
Likes Received: 0 in 0 posts
Likes Given: 0
Country:
Hi all,
There is a system role called @Recipient and default group that we can use in a workflow for validation purpose for example. The action is assigned to a group, and to a specific recipient in this group.
We would need more or less the same role: our need is to be able to send a validation either to the recipient only, or to a group depending on particular criteria.
Is there a way to implement such rules in a customized role and avoid several conditional steps in our workflows?
Thanks in advance for your help.
lmoranne, proud to be a member of EV CONNECT FORUM since Jan 2018.
•
Posts: 377
Threads: 0
Joined: Nov 2015
Likes Received: 34 in 33 posts
Likes Given: 1
Country:
(11-05-2019, 03:12 AM)lmoranne Wrote: Hi all,
There is a system role called @Recipient and default group that we can use in a workflow for validation purpose for example. The action is assigned to a group, and to a specific recipient in this group.
We would need more or less the same role: our need is to be able to send a validation either to the recipient only, or to a group depending on particular criteria.
Is there a way to implement such rules in a customized role and avoid several conditional steps in our workflows?
Thanks in advance for your help.
Hello,
You can create your own role on Administration/Parameters/Custom role
See wiki :
https://wiki.easyvista.com/xwiki/bin/vie...anguage=fr
P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.
•
Posts: 109
Threads: 3
Joined: Nov 2015
Likes Received: 15 in 14 posts
Likes Given: 1
Country:
I'm not aware of a way to have a custom role return an employee_id OR group_id since the custom role configurator requires you to specify which the role will return.
Jack Reeder
FMX Solutions Inc.
Jack.Reeder@fmxsolutions.com
•
Posts: 500
Threads: 69
Joined: Sep 2015
Likes Received: 16 in 14 posts
Likes Given: 1
Country:
Try using a UNION in your SQL statement, so the first part would search for the User ID and then the second part the Group ID, I think that the UNION would allow you to return one or the other based on the criteria... for example User email vs. Group email:
Select AM_EMPLOYEE.E_MAIL from AM_EMPLOYEE
inner join AM_ACTION on AM_EMPLOYEE.EMPLOYEE_ID = AM_ACTION.DONE_BY_ID
where AM_ACTION.ACTION_TYPE_ID in (20,34)
And AM_ACTION.END_DATE_UT IS NULL
And AM_ACTION.DONE_BY_ID IS not NULL
And AM_ACTION.REQUEST_ID in (@ID@)
Union
Select AM_GROUP.EMAIL from AM_GROUP
inner join AM_ACTION on AM_GROUP.GROUP_ID = AM_ACTION.GROUP_ID
where AM_ACTION.ACTION_TYPE_ID in (20,34)
And AM_ACTION.END_DATE_UT IS NULL
And AM_ACTION.DONE_BY_ID IS NULL
and ISNULL(AM_GROUP.EMAIL,'') not like ''
And AM_ACTION.REQUEST_ID in (@ID@)
Andrew E. Reynolds
Director, Professional Services
•