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()));
}
}
{
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