Value is not auto populating

[Deepu]

we are trying to update owner on terminate through update form 

Attribute Name*	owneronTerminateName
Request Type	User
Attribute Label	Owner on Terminate UserName
Attribute Group	4. Owner on Terminate
Order Index	0
Attribute Type	Single select from sql Query
Values	select Concat(firstname,' ', lastname,' (', username, ')') as id  FROM users;
Default Values
Action String
User Column	Customproperty37
What action to perform when Parent attribute changes?	Mapping

 Required 

 Editable On Update 

 Hide On Create 

Attribute Name*	owneronTerminated
Request Type	User
Attribute Label	Owner on Terminate
Attribute Group	4. Owner on Terminate
Order Index	1
Attribute Type	Single select from sql Query
Values	SELECT userkey AS id FROM users WHERE CONCAT(firstname, ' ', lastname, ' (',username, ')') = ${owneronTerminateName};
Default Values	SELECT userkey AS id FROM users WHERE CONCAT(firstname, ' ', lastname, ' (',username, ')') = ${owneronTerminateName};
Action String
User Column	owneronTerminate
Parent Attribute	OwneronTerminateName
What action to perform when Parent attribute changes?	Mapping

 Required 

 Editable On Update 

 Hide On Create 

When I select on Owner On terminate username it should auto populate the value in owner on terminate field but it is not working as expected.  Can someone help me .

[rushikeshvartak]

Is this new/update request ?

[Deepu]

Thanks Rushi for quick response.

For the user who has a value in the Owner on Terminate field and wants to update it to a new value, the field is not auto-populating. The same applies for the user whose Owner on Terminate field is empty

[rushikeshvartak]

owneronTerminateName - custompropert37 should be lower case and what is value stored for user shown in screenshot

owneronTerminate - should be in lower case in users column

[Deepu]

Iam getting error when I change value to owneronTerminate to owneronterminate

For users who do not have an existing value for the Owner on Terminate field, the field will be empty. For users who have an existing value in the Owner on Terminate field, the value will be displayed as "first name last name (system username)"

[rushikeshvartak]

what is value stored in cp37

[Deepu]

[rushikeshvartak]

Try removing brackets 

[Deepu]

Still same issue 

[Deepu]

any idea why it is not auto populating

[Deepu]

any thoughts?

[Deepu]

any idea how to fix this

[Deepu]

Is there any alternative method to implement this feature? We are aiming to enable ownership transfer through the update form, allowing users to directly make the necessary updates. Alternatively, are there any other options available for achieving this functionality?

[shivmano]

@Deepu can you make the below changes to your parent and child attribute and check again 

For parent attribute: owneronTerminateName

What action to perform when Parent attribute changes?

Mapping

For Child attribute: owneronTerminated

Parent Attribute	owneronTerminateName
What action to perform when Parent attribute changes?	Refresh

[Deepu]

I made changes still not working