Getting Invalid reference when searching with the data already present in the reference field

SWAPNAG67418591
Tera Contributor

SWAPNAG67418591_0-1763560822915.png

see the above pic , i am trying to getting the data that is employee name from the employee table but I am not able to search with user first name, last name or email.
I am getting the error like invalid reference but when I search with the field employee id , I am not getting that invalid msg.

SWAPNAG67418591_1-1763560994690.png

what should I do now? I need emoployee name in that field. 

1 ACCEPTED SOLUTION

RaghavSh
Mega Patron

The reference field will only display the field which is marked "display=true" on table.

So example any reference field referring user table will show name as name is marked as display true(sys_dictionary).

 

if the screenshot you shared is OOB, I would not recommend changing the display value of that table. 


Please mark the answer correct/helpful accordingly.


Raghav
MVP 2023
LinkedIn

View solution in original post

2 REPLIES 2

RaghavSh
Mega Patron

The reference field will only display the field which is marked "display=true" on table.

So example any reference field referring user table will show name as name is marked as display true(sys_dictionary).

 

if the screenshot you shared is OOB, I would not recommend changing the display value of that table. 


Please mark the answer correct/helpful accordingly.


Raghav
MVP 2023
LinkedIn

SWAPNAG67418591
Tera Contributor

Thanks for the reply Raghav