user update rule without IMPORT

[Roua]

Hello,
Our HCM import process takes around 4 hours to complete. The import has just finished, but we encountered an issue where the user update rule did not trigger correctly. We've fixed the issue and now need to know if it's possible to trigger the user update rule for the current users without running the entire import again.

Is it feasible to achieve this by creating an enhanced query job or through any other method?
fro example: in the enhanced job query: 

SELECT
userkey AS USERS__USERKEY,
username,
createdate,
updatedate
FROM
users
WHERE
DATE(createdate) = '2024-07-29'
OR DATE(updatedate) = '2024-07-29';

the following query i have for the join user update rule: (already tested and it is working)
it is basically to create accounts using the technical rule

a.customproperty5 = 'A' 
AND a.statuskey = 1 
AND (##a.customproperty5 is updated##)
AND (##a.statuskey is updated##)

and for the technical rule: (already tested and it is working)

a.statuskey = 1
AND a.startdate = CURDATE()

Thank you!

[Raghu]

@Roua  users table we can't  update via enhanced query , it restricted. try using inline preproccer

[rushikeshvartak]

• Workarounds
  • 1Create new rule and update users' customproperty so impacted users can be call user update rule
  • Use Analytics report to provide access to users.