Enhancement query_help required

[Bandi]

Hi Team,

Can you please help to convert the below custom query job used in V.23.5 

to Enhancement query in V24.7

Insert ignore into CUSTOMER_USERS select c.customerkey , u.userkey, '2024-09-03 04:36:41.0','179' from users u, accounts ac, customer c where ac.endpointkey=3 and ac.customproperty10=c.customername and u.username=ac.name and u.employeetype ='External' and u.username in
('800011930')

Thanks

[rushikeshvartak]

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:

• customer_users

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

•