We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

MODIFYUSERDATAJSON - PREPROCESSQUERIES TERMDATE

Jillustre
New Contributor III
New Contributor III

Hey.

having difficult time to do a condition on an update into PREPROCESSQUERIES

I've add the TER'DATE into the AdditionalTables then in my PREPROCESSQUERIES I have

"UPDATE NEWUSERDATA SET STATUSKEY = CASE WHEN CUSTOMPROPERTY1='Active' AND TERMDATE IS NULL THEN '1' ELSE '0' END"

When launching the job, it tell me Error - to Import Data correctly: Error in Users
Import - Error while processing data: Unknown
column 'TERMDATE' in 'field list'

That can cause that? Did I have the good field name? in Dataanalyser is good!

thanks for the help

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

"UPDATE NEWUSERDATA SET NEWUSERDATA.STATUSKEY = CASE WHEN NEWUSERDATA.CUSTOMPROPERTY1='Active' AND NEWUSERDATA.TERMDATE IS NULL THEN '1' ELSE '0' END"

You need to join CURRENTUSERTDATA


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Jillustre
New Contributor III
New Contributor III

Not sure why the previous without TERMDATE using only CUSTOMPROPERTY1 in the Case statement was working then.