Workflow Custom assignment to usersgroup

[JPMac]

We have created a custom assignment workflow that requires approval from a user group.

However, instead of specifying a static string for the user group, we want to assign the user group based on the value in the user's  'userType', appending the string "Group" to it.

For example, if the user's 'userType' is "Sales", the user group should be "SalesGroup".

*failed query : select concat(users.userType,'Group') from users

Could you please let us know how to configure this to read the 'userType' and set "SalesGroup" as the approver?

[Raghu · Accepted solution]

@JPMac  use below query in workflow and select Customquery:

Query :

select userkey from user_groups ug join usergroup_users ugu on ugu.USER_GROUPKEY = ug.USERGROUPKEY and user_groupname=concat('${users.userType}', 'Group')

[JPMac]

@Raghu Thanks for your resposne. It's working.

select userkey

from user_groups ug

join usergroup_users ugu on ugu.USER_GROUPKEY = ug.USERGROUPKEY

where user_groupname=concat('${users.employeeType}','Group')

[Raghu]

Thanks for confirmation.