Thursday, 17 January 2019

workers / employees under line manager x++

static void workerUnderLineManager(Args _args)
{
HcmWorker hcmWorker;
HcmPositionWorkerAssignment workerAssignment;
HcmPosition hcmPosition;
HcmPositionDetail hcmPositionDetail;
HcmPositionHierarchy hcmPositionHierarchy;

while select recid, person , PersonnelNumber from hcmWorker
join worker, position from workerAssignment
where workerAssignment.Worker == hcmWorker.RecId
join recid from hcmPosition
where hcmPosition.RecId == workerAssignment.Position
join hcmPositionHierarchy
where hcmPositionHierarchy.Position == hcmPosition.RecId
&& hcmPositionHierarchy.ParentPosition == 5637153727 // pass the position here
join hcmPositionDetail
where hcmPositionDetail.Position == hcmPosition.RecId

{
info(strFmt(“Name :%1’s , EmployeeId :%2 , position :%3 , Reporting to:%4 “,hcmWorker.name(),hcmWorker.PersonnelNumber,
hcmPositionDetail.Description,hcmPosition::find(hcmPositionHierarchy.ParentPosition).description()));
}
}

No comments:

Post a Comment