Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Custom assignment using customproperty1

PVoehrs
New Contributor III
New Contributor III

Hi,
When we request an user creation, we want to load the group of approvers dynamically. Therefore we used an organisation, which has the approver group name as customproperty1. We understood, that we have to provide the list of userkey and not just the groupname. When we created the query with a static groupname in the where-clause all worked well. When we now changed it to ${users.customproperty1} or ${user.customproperty1} the request gets auto approved as the workflow seems to fail.

When creating a new user the organisation has to be specified in Org Name (customproperty1)

FIELD NAME VALUE

First Nametest
Org NameTest Org 1
lastnameasds
usernamelowerfirstname.asds

These are the queries we used:

select userkey from usergroup_users where user_groupkey in(select usergroupkey from user_groups where user_groupname in (select customproperty1 from customer where customername = '${user.customproperty1}'))   -------NOK

select userkey from usergroup_users where user_groupkey in(select usergroupkey from user_groups where user_groupname in (select customproperty1 from customer where customername = ${user.customproperty1}))   ----------NOK

select userkey from usergroup_users where user_groupkey in(select usergroupkey from user_groups where user_groupname in (select customproperty1 from customer where customername = 'Test Org 1'))    -------OK

 

Any suggestions?

2 REPLIES 2

nimitdave
Saviynt Employee
Saviynt Employee

Please try once as below:

select userkey from usergroup_users where user_groupkey in(select usergroupkey from user_groups where user_groupname in (select customproperty1 from customer where customername = '${customproperty1}'))

PVoehrs
New Contributor III
New Contributor III

Thank you, that was the trick.