Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/03/2024 08:42 AM
We need to update the customproperty of entitlement value 2 with Entitlement_type 2 with the value of entitlement value 1 entitlement_type 1 , We have written an Advanced Query for that. Its not working. Can you please help us on this ??
select e.ENTITLEMENT_VALUE as entitlement_values__customproperty15,r.ENTITLEMENT_VALUEKEY as entitlement_values__PRIMARYKEY
from entitlement_values e,entitlement_values r, entitlement_types et,entitlement_types et1 where e.entitlementtypekey=et.entitlementtypekey and r.ENTITLEMENTTYPEKEY=et1.ENTITLEMENTTYPEKEY and et1.endpointkey='263' and e.ENTITLEMENTTYPEKEY='470' and r.ENTITLEMENTTYPEKEY='439' and e.customproperty1=r.customproperty2