need help for an enhanced query

[pradeeppalagiri]

How we can rewrite below custom query to enhanced query by select (set eo.userkey=ec.userkey) in enhanced query. 

Update entitlement_owners eo

inner join entitlement_values ev on

eo.ENTITLEMENT_VALUEKEY = ev.ENTITLEMENT_VALUEKEY

inner join entitlement_types et on

ev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY

inner join endpoints ep on et.endpointkey=ep.endpointkey

inner join endpoint_certifier ec

on ep.endpointkey= ec.endpointkey

set eo.userkey=ec.userkey

where ec.Rank=26 and eo.Rank=26

[Raghu]

@pradeeppalagiri  please check below also same one

https://forums.saviynt.com/t5/identity-governance/convert-customquery-to-enhanced-query-job/m-p/1062...

[rushikeshvartak]

Entitlement owners table consist of composite key hence enhanced query is not supported for entitlement_owners table

Currently, the existing feature does not possess the ability to update tables featuring composite primary keys. The following tables cannot undergo updates due to this inherent constraint:

• entitlement_owners

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat... 

•