How to get description from payrollearningcode table on the form

(0) Share

Report

Posted on by RameshVaishya

Hi,

I'm getting stuck at description of PayrollEarningCode.Description. Based on below code, I'm getting recid of the table but unable to get description.

earncode = PayrollWorkerPositionEarningCode::findByPosition(hcmPosition.RecId);
select payrollEarningCode where payrollEarningCode.RecId == earncode.RecId;
jmgTmpPayExport.DXCEarnCodeStr = payrollEarningCode.Description;

I tried to find by payrollearning::findByearningcode(earncode.earningcode/recid).description; but it didn't work.

Is there anyone who can assist on it?

Thanks,

All responses (1)

Answers (1)

Verified answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: How to get description from payrollearningcode table on the form

Did you look at the relations of these tables? I don't have a system at hand so I can't check but I'm pretty sure you should be able to find the information by looking at the relations.

PayrollWorkerPositionEarningCode.RecId is definetely not related to PayrollEarningCode.RecId. RecId is always unique identifier of a record in a table, it's never pointing to other tables.