Workflow Custom Assignment to User Attribute

[KK]

Hi.

I have an issue about workflow custom assignment to user attribute.

I set user's custom property1 as approver's username.

In workflow configuration, set custom property1 as user field.

And set this workflow to security system.

Then, do access request, but the request is not assigned to the user who is set in custom property1(assigned to another admin user).

Is my configuration wrong?

Best Regards,

[NM]

@KK try setting userkey instead of username

2) select custom query in custom assignment block and write a query to pass approves userkey 

Query

Select u1.userkey from users u, users u1 where u.customproperty1=u1.username

[KK]

@NM 
Thank you.

I set userkey instead of username, but request is not assigned to the appropriate user.

For 2nd option(Select u1.userkey from users u, users u1 where u.customproperty1=u1.username), also request is not assigned to the appropriate user. If I enter this query in data analyzer many records are hit and actually, request is assigned to many user.

I tried below query, but the request is is not assigned to the appropriate user.

select userkey from users where username = ${user.customproperty1}

Any other ideas?

Best Regards,

[NM]

@KK you need to specify more conditions

Instead of userkey now keep username in users customproperty 1

Select u1.userkey from users u, users u1 where u.customproperty1=u1.username and u.userkey==${user.id}

@KK try this 

[Raghu]

@KK  Can you try above query in CustomQuery select box check it.

[KK]

@NM @Raghu 
Thank you.
I set as it, but request is not assigned to the appropriate user.

Any other ideas?

Best Regards,

[NM]

@KK share workflow wiring ss

[Raghu]

Cp1 is accountname or Global id ? share screenshot below query scrneshot sample 2 users  and now your workflow ss

Select username,customproperty1,systemusername,userkey from users where username in (cp1)

[KK]

@NM @Raghu 
This is current workflow.

And this is query result. I set CP1 as approver's username.

Best Regards,

[NM]

@KK what is the issue??

[KK]

@NM 
When user do access request, I want to assign custom approver, not only manager.
For example, when user "kawatest1001-1" do access request, I want to assign user "kawamanager" as approver.
So, I set "kawamanager" to user "kawatest1001-1"'s custom property1.

And in workflow, I use custom assignment as custom property1.

Then, user "kawatest1001-1" do access request, but the request is not assigned to "kawamanager".
This is initial issue.
And I did several change in workflow based on answers of this thread , but not solved yet.

What I want to do is assign custom approver not only manager.
The custom approvers vary from user to user. So, I plan to custom approver information to user's custom property.
How to realize this?

Best Regards,