02/24/2023 03:36 AM
I am trying to add a secondary manager attribute to all of the users in our organization, according to the rank of the organization owners (1,2).
I have already added a manager to every user using this query (THIS WORKS):
Anyone know why the SecondaryManager Attribute does not get filled in?
02/24/2023 09:30 AM
UPDATE NEWUSERDATA INNER JOIN CURRENTCUSTOMER C ON UPPER(NEWUSERDATA.COMPANY) = UPPER(C.CUSTOMERNAME) INNER JOIN CURRENTORGANIZATION_OWNERS O ON C.CUSTOMERKEY = O.CUSTOMERKEY INNER JOIN CURRENTUSERS U ON O.USERKEY=U.USERKEY SET SECONDARYMANAGER=U.USERNAME WHERE O.RANK=2
02/26/2023 11:04 PM
I just tried it, it's the same result as my query. No error, but secondarymanager attribute is not filled.