m2m table display value

Scheb
Kilo Explorer

‎03-22-2013 11:16 PM

Let's see if anyone knows an answer to this. We've created a list collector variable (or reference variable...both fail) and pointed it to a table made by inserting a row into the sys_m2m table (u_m2m...). The list collector as well as the reference field shows the sys_id.

"Aha!" you say, you didn't set the display value field - so I set the display value field and lo and behold, it doesn't work - the sys_id still stands. Any ideas why?

Thanks,

Adam

PS: stupid question, but is this because the display field in the dictionary can't be set to a reference field?

0 Helpfuls
  • 1,130 Views
2 REPLIES 2

adiddigi
Tera Guru

‎03-24-2013 12:50 AM

This doesn't work as both are references. One way which should fix your problem is to use a calculated field and set the display to it.

https://wiki.servicenow.com/index.php?title=System_Dictionary

There might be a better way...


0 Helpfuls

sherard
Mega Expert
In response to adiddigi

‎08-16-2013 12:10 PM

I am having the same issue that the list shows the sys_id of a reference field. However, the form view of the record does show the Display Value correctly. It's just the list view of that field column that displays the sys_id.

Did you get this resolved and how?


0 Helpfuls