Display value in Global Search for M2M table

Adrian43
Kilo Contributor

Hi all,

I have a Many to Many table with two reference fields which is relating two tables (A and B). This Many to Many table has as "Display" the reference field from table B and the table B has as "Display" the field ID.

The problem I have is when I try to use the Global Search, when the records from the M2M table are found, I see the SysID instead of the "Display".

Can someone help me with this issue?

Thank you in advance.

Adrian.

 

4 REPLIES 4

Aman Kumar S
Kilo Patron

That is because, you don't have display value set for m2m table, once you set that, it will show you the display value

Best Regards
Aman Kumar

Hi Aman,

Thank you for the response. I already have a display value for the m2m (its set as table B field). The point is that if I get this display value via script it's shown correctly.

Regards.

Can you share the code that you are using? And if i understand correctly, if you set up a reference field as display it is supposed to give your sysid by design right. If you think about it, display values are usually number or name, and if you set it as reference sysid is what you get, but I will research it further and get back to you but i think this is expected behaviour
Best Regards
Aman Kumar

I attached screenshots with the configuration for the Display fields.