Share
Report
2,016greeting everyone
i'm already created report but in my report i need only to appearance the duplicate depending on column
here in my code need only the duplicated workers depend on personal number
while select hcmPositionWorkerAssignment where hcmPositionWorkerAssignment.Worker==hcmWorkerRecId
&& ( (hcmPositionWorkerAssignment.ValidFrom >= fromDate) && (hcmPositionWorkerAssignment.ValidFrom <= toDate) )
{
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();
}
mean if the personal number has been duplicated show them only if not duplicated don't show them
the idea of my report is giving me all workers which have more than position whatever if he in current or already terminate
All responses (
Answers (
