Want to check employee record if it matches with the new applicant

(0) Share

Report

Posted on by Siddhant Singh

502

Hello all,

I want to check duplicate employee record with the new applicant if employee name ,DOB and passport number matches with New applicant record with Name, Dob and passport number.

If new applicant record matches with existing record, the system must through warning message.

Validation at applicant record creation:

Trigger: On save of an applicant record.

Can I have to write code on the post handler of validatewrite()?

Where and what code can be written to do so.

Thank you

Siddhant Singh

*This post is locked for comments

All responses (4)

Answers (0)

Siddhant Singh 502 on at

Like (0)

Report

RE: Want to check employee record if it matches with the new applicant

Hi Guru,

Actually when the new applicant is entered by the user it gets entered. After that New Application will be created with the same name of the applicant and when the user saves the New Application, the system has to check with that if (Name and Dob) or (Name and Passport number) or (Dob and Passport number) matches it should show warning message.

And I have written the code on data source of the for HRMApplication Form by extending the form and copying the post handler onValidateWrite of the data source as whenever the data source is hit after the save the system will chack for the values required for the validation.
Guruprasanna 1,048 on at

Like (0)

Report

RE: Want to check employee record if it matches with the new applicant

Hi Siddhant,

as per my understanding,"BirthDate" and "Passport" fields are not a mandatory fields for creating employee. When you click new button on the employee form only name and employee date are the mandatory fields. Hence you can enter either "Birth date" or "Passport" number after the employee creation. However you can find the duplicate employee based on the employee name, Birth Date and pass port number fields. So, for this we have to write code in postEventHandler of "validateWrite" method of the "HcmPersonPrivateDetails". Please find the below piece of code.

[PostHandlerFor(tableStr(HcmPersonPrivateDetails), tableMethodStr(HcmPersonPrivateDetails, validateWrite))]
public static void HcmPersonPrivateDetails_Post_validateWrite(XppPrePostArgs args)
{
HcmPersonPrivateDetails privateDetails = args.getThis();
DirPersonName personNameCurrent = DirPersonName::find(privateDetails.Person);
HcmIdentificationType identificationType = HcmIdentificationType::findByIdentificationType("Passport");
DirPersonName personNameOrig;
HcmPersonIdentificationNumber identificationNumberOrig;
HcmPersonIdentificationNumber identificationNumber = HcmPersonIdentificationNumber::findByPersonAndType(privateDetails.Person, identificationType.RecId);
HcmPersonPrivateDetails privateDetailsOrig;

select * from personNameOrig
where personNameOrig.FirstName == personNameCurrent.FirstName
&& personNameOrig.LastName == personNameCurrent.LastName
&& personNameOrig.RecId != personNameCurrent.RecId
exists join identificationNumberOrig
where identificationNumberOrig.IdentificationType == identificationType.RecId
&& identificationNumberOrig.IdentificationNumber == identificationNumber.IdentificationNumber
&& identificationNumberOrig.Person == personNameOrig.Person
exists join privateDetailsOrig
where privateDetailsOrig.BirthDate == privateDetails.BirthDate
&& privateDetailsOrig.Person == personNameOrig.Person;

if (personNameOrig)
{
checkFailed("Required error message");
args.setReturnValue(false);
}
}

Write similar code on the post event handler of "validateWrite" method of "HcmPersonIdentificationNumber" table because user can enter first birthdate then passport number or vice versa.

I hope this might help you !

regards

Guru
Siddhant Singh 502 on at

Like (0)

Report

RE: Want to check employee record if it matches with the new applicant

Hello guru,

I have written method and call it in the post handler dirPersonName.

These errors are coming.

Thank you

Siddhant Singh
Guruprasanna 1,048 on at

Like (0)

Report

RE: Want to check employee record if it matches with the new applicant

Hi Siddhant,

you can write the code in the "onValidatingWrite" events of the "DirPersonName" table. If you open validate write method of this table you can see similar type of validation is exists for the name. And you can use the similar query something like below.

DirPersonName personName;
HcmPersonIdentificationNumber identificationNumber;
HcmPersonPrivateDetails personPrivateDetails;
HcmIdentificationType identificationType = HcmIdentificationType::findByIdentificationType("Passport");

select * from personName
where personName.FirstName == "Firstname"
&& personName.LastName == "LastName"
exists join identificationNumber
where identificationNumber.IdentificationType == identificationType.RecId
&& identificationNumber.IdentificationNumber == "PassportNumber"
&& identificationNumber.Person == personName.Person
exists join personPrivateDetails
where personPrivateDetails.BirthDate == "birthDate"
&& personPrivateDetails.Person == personName.Person;

If you find the records for the above combination then you can throw the warning message.

I hope this might help you

Regards

Guru