Issue with Customproperty of an entitlement

[HarshaVP]

We are facing an issue while updating the Customproperty value of an entitlement to NULL using the enhanced query job. Instead of making the customproperty value void or blank, the job is updating it to the word "NULL"

Please find the query we are using below. Kindly suggest if there is any way to make the customproperty value NULL and void and not update it to the word "NULL"

SELECT NULL AS entitlement_values__customproperty25,entitlement_valuekey as entitlement_values__primaryKey FROM entitlement_values WHERE UPPER(ENTITLEMENT_VALUE) IN ('')

[adarshk]

Hi @HarshaVP 

Please use the below query:

SELECT '' AS entitlement_values__customproperty25,ev.entitlement_valuekey as entitlement_values__primaryKey FROM entitlement_values ev WHERE UPPER(ev.ENTITLEMENT_VALUE) IN ('E1')

E1 -> Sample Entitlement_Value
*make sure this is used on a single entitlement value before updating it on bulk entries. 

[rushikeshvartak]

SELECT 0 AS entitlement_values__customproperty25,entitlement_valuekey as entitlement_values__primaryKey FROM entitlement_values WHERE UPPER(ENTITLEMENT_VALUE) IN ('')