Search for employee number in a reference field

[scottangehr]

Hello team

I'm trying to do a reverse search for the value of a reference field to query the employee number vs the name.

We want the end user to provide their employee number to drive the name.

I tried some dot-walking options, but could not retrieve the data.

Thank you

Scott

[scottangehr]

The reference is to the sys_user table.

[Dr Atul G- LNG · Accepted solution]

Hi @scottangehr 

If I understood correctly , you want in requested for , a user will be able to search by employee number as well, if this is the case so you need to add the attribute in variable.

[scottangehr]

Thank you kindly!  That got me in the right direction.

Appreciate your fast response!

Regards,

Scott