Get worker name from Employee position with SQL Queries in dynamics AX 2012
select top 1 name
from DIRPARTYTABLE
inner join HcmWorker
ON HcmWorker.PERSON = DIRPARTYTABLE.RECID
AND HcmWorker.RECID
=
(select
top 1 worker from HCMPOSITIONWORKERASSIGNMENT
INNER
JOIN HCMPOSITION ON HCMPOSITIONWORKERASSIGNMENT.POSITION = HCMPOSITION.RECID
AND
HCMPOSITION.POSITIONID = 'POS123'
where
GETDATE() between HCMPOSITIONWORKERASSIGNMENT.VALIDFROM AND
HCMPOSITIONWORKERASSIGNMENT.VALIDTO);
thanks,
Vikas Mehta.
