Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Issue with Customproperty of an entitlement

HarshaVP
New Contributor II
New Contributor II

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 ('')

2 REPLIES 2

adarshk
Saviynt Employee
Saviynt Employee

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
All-Star
All-Star

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


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