How to maximize limit of records in lookup selectbox variable

Himanshi3
Tera Contributor

‎09-25-2020 08:05 AM

Hi,

I am using a lookup select box variable in a catalog item to display User id from user table. I can't use Reference variable instead of lookup select box as User table has display field as "Name" instead of "User id". Also, I can't change the display field from name to user id since it will globally affect all other modules.

However, lookup selectbox variable is not showing all the records from user table and showing limited number of user ids. It might be due to large size of user data. Also, when I search with user id, it is not searching as it is containing limited number of user ids.

Please suggest which approach should be followed here to display all the records in lookup select box.

Thanks.

0 Helpfuls
  • 2,967 Views
5 REPLIES 5

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

‎09-25-2020 09:03 AM

Hi Himanshi - I don't think there is a restriction as such for lookup select box. Also I didn't find any such service catalog related property https://docs.servicenow.com/bundle/paris-servicenow-platform/page/product/service-catalog-management.... Can you check if there are any reference qualifier restricting the results? However the recommendation is to switch to a reference field if the choice values have records >25

0 Helpfuls