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

[Raghu]

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%';

[MichaelSchmid]

Hi Raghu,

thank you but now I'm getting a new error message.

[Raghu · Accepted solution]

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