Hi,
We are trying to update a set of users' manager when the manager becomes inactive. The new manager to be updated is manager's manager.
We are using the following query in advanced query in user update rule.
a.username like '9%' AND a.statuskey=1 AND a.manager in (select u.id from Users u where u.id=a.manager AND (##u.statuskey isupdated##) AND u.statuskey=0)
But this is not working as expected.
Could you please help ?
Thanks & Regards,
Sinchana
