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

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...