Unable to copy and paste the data in customproperty from Inline processor

[Varshi_Balaji]

Hi Team,

We are trying to copy the data present in customproperty3 and update the same value in customproperty56. We are using modifyuserdata json in sav4sav rest connector.

We followed the steps given in the below link

https://forums.saviynt.com/t5/identity-governance/sav4sav-rest-user-import-and-modifyuserdatajson-im...

We tried many methods to update the customproperty,it is not working.

{
"ADDITIONALTABLES": {
"USERS": "SELECT USERNAME,CUSTOMPROPERTY56,CUSTOMPROPERTY3 FROM USERS"
},
"COMPUTEDCOLUMNS": [
"CUSTOMPROPERTY56"
],
"TABLEINDEXES": {
"CURRENTUSERS": [
"USERNAME",
"CUSTOMPROPERTY3",
"CUSTOMPROPERTY56"
]
},
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET CUSTOMPROPERTY56 = (select CUSTOMPROPERTY3 from currentusers)"
]
}

Can you please help us here

Reagrds,

Varshitha

[rushikeshvartak]

UPDATE NEWUSERDATA
SET CUSTOMPROPERTY56 = (
SELECT CUSTOMPROPERTY3
FROM CURRENTUSERS
WHERE CURRENTUSERS.USERNAME = NEWUSERDATA.USERNAME
)