and more in a single search tool across platforms. Read the announcement here. |
04/24/2023 08:30 PM
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 .
04/24/2023 08:35 PM
Is this new/update request ?
04/24/2023 08:39 PM
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
04/24/2023 08:46 PM
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
04/24/2023 08:56 PM
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)"
04/24/2023 09:19 PM
what is value stored in cp37
04/25/2023 08:17 AM
05/01/2023 09:52 PM
Try removing brackets
05/07/2023 07:45 PM
Still same issue
04/27/2023 06:35 AM
any idea why it is not auto populating
05/01/2023 09:32 PM
any thoughts?
05/11/2023 10:20 AM
any idea how to fix this
05/11/2023 08:32 PM
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?
05/30/2023 11:20 PM - edited 05/30/2023 11:26 PM
@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 |
06/05/2023 06:39 AM
I made changes still not working