Need help for an Enhanced Query

[MichaelSchmid]

Hello,

I'm trying to update a customproperty field for an entitlement with a newly created Enhanced Query, but I'm getting the following error messsage.

The query is:

Select '0' AS customproperty1
from entitlement_values ev
WHERE ev.ENTITLEMENT_VALUE LIKE '%_KRED_%';

Can someone tell me what is wrong about this query?
It was possible to access and update this table/column within the old custom query.

BR, Michael

[CR]

try like below

Select '0' AS entitlement_values__customproperty1,e.ENTITLEMENT_VALUEKEY as entitlement_values__PRIMARYKEY from entitlement_values e where
e.ENTITLEMENT_VALUE LIKE '%Payee%';

[PremMahadikar · Accepted solution]

Hi @MichaelSchmid ,

below should work:

Select '0' AS entitlement_values__customproperty1,e.ENTITLEMENT_VALUEKEY as entitlement_values__PRIMARYKEY from entitlement_values e where
e.ENTITLEMENT_VALUE LIKE '%_TEST_%';