Obtain user id from user table reference field

eswarijk
Tera Contributor

‎12-26-2016 02:18 AM

One of the fields of my table is a reference type of USER table.

The Table is mapped to a module from which I can perform List Editing.Refer the below picture for reference.

Screenshot (184).png

I am obtaining the User name as the return value from the user table reference field

But I need User ID instead of User name to be returned.

How should I configure in order to achieve this?

Preview file
49 KB
0 Helpfuls
  • 2,285 Views
3 REPLIES 3

nayanawadhiya1
Kilo Sage

‎12-26-2016 02:40 AM

Hey Eswari,


        You have configure the Attribute for that field.


        This will help you Dictionary Attributes - ServiceNow Wiki


0 Helpfuls

eswarijk
Tera Contributor
In response to nayanawadhiya1

‎12-26-2016 04:08 AM

What will be the attribute name to set employee number as display value in the reference field?


0 Helpfuls

dvp
Mega Sage
Mega Sage

‎12-26-2016 06:11 AM

You need to write a dictionary override on the reference field



Here is the link Dictionary Overrides - ServiceNow Wiki 



Override display value Select the check box to use this field as the display value on the extended table. 

For example, the Story [rm_story] table uses the short description as the display value in reference fields instead of the number, as defined in the Task [task] table.

0 Helpfuls