displaymethod to get employee countryregionid

Finance and Operations/AX Developer Forum
1

hi all ,

is it possible to have a displaymethod in empltable to get the countryregionid of the employee.?

thanks

2

HI Guys!!!

i have created a display method

display AddressCountryRegionId SARdisplayEmployeeCountryRegion()
{
DirPartyAddressRelationship partyAddressRelationship;

DirPartyAddressRelationshipMapping addressRelationshipMapping;
Address address;

AddressCountryRegionId ret;
;

select addressRelationshipMapping
join partyAddressRelationship
where partyAddressRelationship.PartyId == this.PartyId && partyAddressRelationship.IsPrimary &&
partyAddressRelationship.RecId == addressRelationshipMapping.PartyAddressRelationshipRecId
join address
where address.RecId == addressRelationshipMapping.AddressRecId &&
address.DataAreaId == addressRelationshipMapping.RefCompanyId;

if(address)
ret = address.CountryRegionId;
else
ret = ‘’;

return ret ;
}

Thanks