Reference variable shows sys_id instead of user name

[gnunez]

Hello all,

We created a catalog item that integrates with an app in SNOW store and have succesfully tested, but only downside is when capturing the variable (variable type is Reference) the sys_id is showing instead of the user's first and last name. Is there any way to change this default setting to set the name instead of the sys_id?

Also we are referencing the sys_user table, don't know if anything in there will make a difference.

Thanks in advance!

Using Istanbul UI16

[andrewpilachows]

Are you using Reference or Lookup Select List?   The value would be sys_id and label would be name.   Is your workflow using setValue or setDisplayValue?   I can see that working for setDisplayValue on a reference/lookup.

[gnunez]

I'm using Reference. I am using the workflow provided by the ServiceNow app eSignifi so the variable is specified in a field box called "First signer custom tabs" as {"tabLabel": "administrator_name", "value":"${current.variables.administrator_name.name}"}

[andrewpilachows]

Interesting, must do something like a set by display value thing then which would require the name.

[gnunez]

Yes I'm guessing the workflow is using setDisplayValue.

[andrewpilachows]

The issue you are running into is that sys_user table read access ACL is restricted to certain roles.   I would be careful with opening that up, but I do not know what an alternative would be.