Thursday, 17 January 2019

Civil Id of a employee (kuwait region) x++

static void getCivilId(Args _args)
{
HcmWorker hcmWorker;
HcmPersonIdentificationNumber hcmPersonIdentificationNumber;
DirPerson dirPerson;
HcmIdentificationType hcmIdentificationType;

select hcmWorker
where hcmWorker.PersonnelNumber == “854”
join dirPerson
where dirPerson.RecId == hcmWorker.Person
join hcmPersonIdentificationNumber
where hcmPersonIdentificationNumber.Person == dirPerson.RecId
join hcmIdentificationType
where hcmIdentificationType.RecId == hcmPersonIdentificationNumber.IdentificationType
&& hcmIdentificationType.IdentificationTypeId == “Civil id”;

info(strFmt(“%1”,hcmPersonIdentificationNumber.IdentificationNumber));
info(strFmt(“%1”,hcmIdentificationType.IdentificationTypeId));
}

No comments:

Post a Comment