How can I connect tables LogisticsElectronicAddress and HcmWorker?

(0) Share

Report

Posted on by Miguel Zuniga

272

I need the PersonnelNumber from HcmWorker table, but the value I am receiving is an E-mail address from LogisticsElectronicAddress is there a possible connection/sql statement where I can find the PersonnelNumber by using the E-mail address? They are in the same form named HcmWorker

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Jonathan Halland 11,310 on at

Like (0)

Report
Hi Miguel,

Obviously you can have multiple employees with the same email in AX, however if your data is logically arranged that it is not like this then you can use something like:

public static HcmWorker getWorkerFromEmail(Email _address) { FieldId primaryFieldId = DirPartyTable::electronicAddressType2primaryFieldId(LogisticsElectronicAddressMethodType::Email); LogisticsElectronicAddress logisticsElectronicAddress; DirPartyTable dirPartyTable; HcmWorker worker; ; select firstonly dirPartyTable exists join logisticsElectronicAddress where dirPartyTable.(primaryFieldId) == logisticsElectronicAddress.RecId && logisticsElectronicAddress.Locator == _address; return HcmWorker::findByPerson(dirPartyTable.RecId); }

Was this reply helpful? Yes No
Miguel Zuniga 272 on at

Like (0)

Report

Hi Jonathan,

I am using this to import on an invoice journal using x++.

trans.parmApprover(HcmWorker::findByPerson(dirPartyTable.RecId));

using HcmWorker::findByPerson(dirPartyTable.RecId) gives me the error of "Argument '_approver' is incompatible with the required type"

Was this reply helpful? Yes No
Suggested answer

Jonathan Halland 11,310 on at

Like (0)

Report

Try trans.parmApprover(HcmWorker::findByPerson(dirPartyTable.RecId).RecId);

Was this reply helpful? Yes No
Miguel Zuniga 272 on at

Like (0)

Report

Tried it Jonathan but it just outputs the value 0

Was this reply helpful? Yes No
Pravasti AK 2,985 on at

Like (0)

Report

Hi Miguel,

Here is the code :

private LogisticsElectronicAddressLocator getInstructorEmail(HcmWorkerRecId _workerRecId)

{

LogisticsElectronicAddress logisticsElectronicAddress;

HcmWorker hcmWorker;

DirPerson dirPerson;

DirPartyTable dirPartyTable;

select hcmWorker

where hcmWorker.RecId == _workerRecId

join dirPerson

where dirPerson.RecId == hcmWorker.Person

join dirPartyTable

where dirPartyTable.RecId == dirPerson.RecId

join logisticsElectronicAddress

where dirPartyTable.PrimaryContactEmail == logisticsElectronicAddress.RecId;

return logisticsElectronicAddress.Locator;

}

Please refer the below link:

http://axbooster.blogspot.fr/2014/06/get-employee-detail-by-code-ax-2012.html

Was this reply helpful? Yes No
Jonathan Halland 11,310 on at

Like (0)

Report

Hi, as a note, Miguel, the code I have above relies on your email address being marked as a primary address on the worker, can you test that, otherwise use Kavitha's code

Was this reply helpful? Yes No
Rati Sharabidze 612 on at

Like (0)

Report

Hello Miguel,

Try this relation:

logisticsElectronicAddress.Location == dirPartyLocation.Location

&& hcmWorker.Person == dirPartyLocation.Party

&& dirPerson.RecId == dirPartyLocation.Party

Best regards

Was this reply helpful? Yes No