Reference variable

Cupcake · ‎06-20-2018

In my catalog item I have a variable that is a reference variable. It is referencing the user table which contains may fields like (Name, Employee ID, Title, etc.). What I want to do is make the reference field show the Employee ID #.

I was successful in doing this using a variable type = Lookup select box; however, it slowed the system down drastically so I changed it to a reference field.

Any help and any ideas on why when I used the lookup select box it slowed the system down.

I am using Jakarta Patch 8B & Service Portal.

Thanks,

Karen

SanjivMeher · ‎06-20-2018

Since the number of users will be more and there is no index on employee id, it will slow down the performance if you use that field in lookup. Instead I would suggest you to use Reference field and add employee number as a ref_ac_columns in the variable attribute

https://docs.servicenow.com/bundle/kingston-it-service-management/page/product/service-catalog-manag...

Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

RobertC93001833 · ‎12-12-2024

6 years later Karen, this saved my bacon. I've been struggling with my reference variables all showing the sysid. Been searching for a while on how to solve this. Thank You !!