MODIFYUSERDATAJSON - PREPROCESSQUERIES TERMDATE

[Jillustre]

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

[rushikeshvartak · Accepted solution]

"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

[Jillustre]

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