static
void
GetEmplPosition(Args _args)
{
HcmWorker hcmWorker;
HcmPositionWorkerAssignment workerAssignment;
HcmPosition hcmPosition;
HcmPositionDetail hcmPositionDetail;
while
select recid, person from hcmWorker
join worker, position from workerAssignment
where workerAssignment.Worker == hcmWorker.RecId
join recid from hcmPosition
where hcmPosition.RecId == workerAssignment.Position
join position, description from hcmPositionDetail
where hcmPositionDetail.Position == hcmPosition.RecId
{
info(strFmt(
"%1's position is %2"
,hcmWorker.name(), hcmPositionDetail.Description));
}
}
static
void
GetEmplPosition(Args _args)
{
HcmWorker hcmWorker;
HcmPositionWorkerAssignment workerAssignment;
HcmPosition hcmPosition;
HcmPositionDetail hcmPositionDetail;
while
select recid, person from hcmWorker
join worker, position from workerAssignment
where workerAssignment.Worker == hcmWorker.RecId
join recid from hcmPosition
where hcmPosition.RecId == workerAssignment.Position
join position, description from hcmPositionDetail
where hcmPositionDetail.Position == hcmPosition.RecId
{
info(strFmt(
"%1's position is %2"
,hcmWorker.name(), hcmPositionDetail.Description));
}
}
No comments:
Post a Comment