greeting everyon
i'v created a new report so in my report i wanna show all Position which Assignment to worker but in my report not show me all Position only show me the current like this
and i need to show all Position like this below
i'm using normal query but still only show me current Position
while select hcmPositionWorkerAssignment where hcmPositionWorkerAssignment.Worker==hcmWorkerRecId
{
TransferEmpReportTemp.clear();
TransferEmpReportTemp.PersonnelNumber=hcmWorker::find(hcmPositionWorkerAssignment.Worker).PersonnelNumber;
TransferEmpReportTemp.WorkerName=hcmWorker::find(hcmPositionWorkerAssignment.Worker).name();
TransferEmpReportTemp.Position=hcmPosition::find(hcmPositionWorkerAssignment.Position).description();
TransferEmpReportTemp.ValidFrom=hcmPositionWorkerAssignment.ValidFrom;
TransferEmpReportTemp.ValidTo=hcmPositionWorkerAssignment.ValidTo;
select * from hcmPosition where hcmPosition.RecId==hcmPositionWorkerAssignment.Position;
select * from hcmPositionDetail
where hcmPositionDetail.Position==hcmPosition.RecId;
select * from oMOperatingUnit
where oMOperatingUnit.RecId==hcmPositionDetail.Department;
TransferEmpReportTemp.Department=oMOperatingUnit.Name;
select PaidByLegalEntity from payrollPositionDetails
where hcmPositionWorkerAssignment.Position==payrollPositionDetails.Position;
select DataArea from companyInfo
where payrollPositionDetails.PaidByLegalEntity==companyInfo.RecID;
TransferEmpReportTemp.Company=companyInfo.Name;
TransferEmpReportTemp.insert();
}
how can i allow all row of that table show in my report?!
