Finance | Project Operations, Human Resources, ...

HCMWorker Person field Lookup

(0) Share

Report

Posted on by dark_knight

1,271

Hello,

I have a custom table where I created a field Person with the same EDT DirPartyRecId in the properties as in the properties of the HCMWorker.Person field. Also I created relations to HCMWorker and other relations exactly as they are created on HCMWorker

I'd like my custom table's field's Person lookup to contain the same Persons as in HCMWorker but for some unknown reason it contains much more values. Some of them are from HCMWorker's Person field, some not. I also know that HCMWoker.Person field contains reference most likely to DirPErson.Name field via relations. IN table browser HCmWorker.Person field contains Names but the filed is int64 recid field.

I think that my lookup contains all values from DirPartyTable because EDT DirPartyRecId contains FormHelo DirPArtyLookup form and there is a route table DirPArtyTable inside.

How to build lookup for mytable.person so that it contains only values from HCMWorker.Person. With other tables I created it easily by creating relations and nothing more. But here it doesn't work.

Thanks.

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

greengrimms 1,400 on at

Like (0)

Report
Copy link

Link copied!
Hi Azat,

You might want to take a look at HcmWorkerLookup class, which already implements logic to show new active workers, employees, contractors.

You'll just need to override lookup method with this code for example:

public void lookup() { HcmWorkerLookup::newOnlyActiveEmployeesWithinCompany().lookupWorker(this); }

Hope it helps.

Was this reply helpful? Yes No
dark_knight 1,271 on at

Like (1)

Report
Copy link

Link copied!

Hi Danilo,

Thanks for the answer. I've resolved the issue just by adding field based on the HCMWorkerRecid EDT to my custom table and creating relation to HCMWorker by RECID. Then I have added this field to the form and it automatically created reference group using DirPerson relation on HCWWorkerTable and it showed me related DirPerson name instead of the RECId. SO it would be easier from the start if I knew this standard EDT. Hope it'll help someone else.

Thanks.

Was this reply helpful? Yes No