Thursday, February 23, 2017

Get Worker to User Id in ax 2012

//Get Worker to User Id in ax 2012


public static UserID Worker2UserId(HcmWorkerRecId _WorkerRecId) // Added by ISYX
{
    DirPersonUser   personUser;
    HcmWorker       worker;
     select User from personUser
         exists join worker
            where worker.Person == personUser.PersonParty
                    && worker.RecId == _WorkerRecId;
   
    return personUser.User;
}

No comments:

Post a Comment

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...