Null is converted to empty string when writing to database.

While updating a table from the process model using WriteToDatastoreEntity node. Even though CDT fields are null, it is updating empty string value in the table. How to update NULL in the table when data is null?

 

Thanks,

Varsha

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Lead Developer
    in reply to AK47

    One fun thing you can do is run it through filternulls() after you have it out of the query.  It shouldn't be THAT much overhead to return a list of nulls from your query, but "IS NULL" and "IS NOT NULL" should be fine if you are querying an integer row. 

    Perhaps wrapping the query in toInteger() would also help.  That should at least theoretically convert null type Text into null type Integer.

Children
No Data