Avatar

Level 2

Hi Folks,

 

I have requirement from a client where in they want to store the NULL value in the integer field of data schema. For the same, I tried multiple things like dropping the constraint of DEFAULT and NOT NULL from the table field. However, I have observered that the UPDATE actvitiy in the workflow uses the COALESCE function while inserting the data. I got to know this by enabling workflow SQL logs. 

nitesh_anwani_1-1642071623451.png

 

I have also tried the option store empty in desitnation field in the advance parameter of update activity.

nitesh_anwani_2-1642071680874.png

 

 

Anything else other than mentioned things to achive this requirement. Any documentation or suggestion is highliy appreciated.

 

Regards,

Nitesh Anwani