CustomQuery to update with users Manager's Manager

[RV]

Can someone please share a query to update a CustomPropertyX on the user profile with their Manager's Manager.

[rushikeshvartak · Accepted solution]

update users u ,users m,users mm set u.customproperty1=mm.username where u.manager=m.userkey and m.manager=mm.userkey limit 10;

[rushikeshvartak]

update users u left join users m on u.manager=m.userkey left join users mm on m.manager=mm.userkey on u.customproperty1=mm.username limit 1;

[RV]

I see you have replied two query,  Is the query to try out as it is setting customproperty1 ?

update users u ,users m,users mm set u.customproperty1=mm.username where u.manager=m.userkey and m.manager=mm.userkey limit 10;

[rushikeshvartak]

Both will work .