need help with workflow. need to populate usergroup name found customproperty4 in entitlements

[venkat]

we have stored the usergroup name in entitlement.customproperty 4.  the following is the code

we tried  the following code in usergroup  

select customproperty4 from entitlement_values where entitlement_valuekey=${REQUESTACCESSOBJ.id}  .

result :the flow goes to admin admin

we tried entitlement.customproperty4  and

result: it also goes to admin admin

we tried the following code

select u.userkey from Users u,Usergroup_users ug where u.userkey=ug.userkey AND ug.user_groupname=(select customproperty4 from entitlement_values where entitlement_valuekey=${REQUESTACCESSOBJ.id}))

result : goes to admin admin

below is the workflow

what is the correct way to populate usergroupname

[PremMahadikar]

Hi @venkat ,

1. Always use customquery in 'Select User Field' when using Query

2. Please use the below query (this is working for me):

SELECT userkey
              FROM   usergroup_users
              WHERE  user_groupkey=
                     (
                            SELECT usergroupkey
                            FROM   user_groups
                            WHERE  user_groupname=
                                   (
                                          SELECT customproperty4
                                          FROM   entitlement_values
                                          WHERE  entitlement_valuekey=${REQUESTACCESSOBJ.id}))

For Query verification before using it in workflow, try it in Data Analyzer.

If this reply answers your question, please consider selecting Accept As Solution and hit kudos.

[CR]

@venkat  Look like you query is correct but Workflow config select type passing UserGroup , if going to use query build better use Custom query select type.

Change select type like below:

you missing below in workflow:

[rushikeshvartak]

Change Select User Field to CustomQuery instead of UserGroup