Get worker name from Employee position with SQL Queries in dynamics AX 2012

 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.