Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

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