How to show Department Name, EmpID, Description.

(0) Share

Report

Posted on by Fawad Ahmad

static void Fawadd(Args _args) { HcmWorker woker; DirpartyTable DirDepart; HcmPositionDetail pstDetail; HcmPositionWorkerAssignment Assign; HcmPositionDuration pst; DirPartyTable party1; // //pstDetail.VALIDFROM, //pstDetail.VALIDTO, //Assign.VALIDFROM, //Assign.VALIDTO, //party.NAMEALIAS as EmpName, //DirDepart.NAME as DeptName while select * from woker join DirDepart where woker.Person==party1.RecId join Assign where Assign.Worker == woker.RecId join pstDetail where Assign.Position == pstDetail.Position join pst where pst.Position == pstDetail.Position join DirDepart where DirDepart.RecId == pstDetail.Department && woker.PersonnelNumber == '00038' { //--DirDepart.NAME='IT' //--party.NAMEALIAS LIKE '%Muhammad Imran%' info(pstDetail.Description); //return DirDepart.Name } }

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

Please tell us which product it's about, so I can move it to the right forum. It surely is X++, therefore it's about either Dynamics AX or D365FO.

Then please post your code again, this time with line breaks and indentation. Utilize Insert > Code in the rich formatting view.

And then explain your question, because you just pasted some code without any explanation of your problem.

Was this reply helpful? Yes No
Fawad Ahmad 61 on at

Like (0)

Report

thanks for your kind information. I want to show my all records on the bases of specific EmployeeID. Now I find that method for this problem solution.

utcDateTime validTo = DateTimeUtil::maxValue();

utcDateTime validFrom = DateTimeUtil::minValue();

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Can you please follow what I said in my previous reply?

Was this reply helpful? Yes No