Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Data Lookups definitions

rvodnala13
Mega Explorer

In Data Lookup Definitions, when there are a large number of choices, it becomes difficult to manually assign a value for each choice. Could you please explain how to handle or overcome this situation efficiently?

3 REPLIES 3

Dr Atul G- LNG
Tera Patron

Better use the Decision table in this case

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

SohamTipnis
Mega Sage

Hi @rvodnala13,

 

You can refer to this article on the decision table:

 

https://www.servicenow.com/docs/r/application-development/decision-tables/decision-table.html

 

If you find my answer useful, please mark it as Helpful and Correct. ‌‌‌‌‌😊


Regards,
Soham Tipnis
ServiceNow Developer ||  Technical Consultant
LinkedIn: www.linkedin.com/in/sohamtipnis10

YashwanthV18760
Giga Guru

Hi @rvodnala13 

 

To efficiently handle large numbers of choices in Data Lookup Definitions:

  • Avoid using lookup multiple choice variables with large tables, as this can cause performance issues. Instead, use reference qualifiers to filter and reduce the data set, or use a reference type variable for better performance.
  • Note that you cannot add more than 10,000 choices to a lookup multiple choice variable