I have a variable called country which is reference to location table, and having a another esn tabl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2025 04:12 AM
I have a variable called country which is reference to location table, and having a another esn table there we have almost 60 countries, we need to show only 60 countries that too we need to refrernce it to location table only.
Please suggest me

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2025 04:23 AM
Hi @Archana23 ,
Your question is not clear, can you elaborate more with some screenshots please .
what is "esn table"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2025 04:54 AM
what's the purpose of both the variables?
what's your business requirement here?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2025 05:04 AM
Esn table is a custon table(u_esn_codes), having almost 60 countries. The thing is this custom table cannot be used , so we need to show only these 60 countries, in the 2nd screenshot having country variable need to show only 60 countries which are available in the custom table but need to give refrence to cmn_location table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2025 05:18 AM
so 2nd variable should show only those ESN codes for the country selected in 1st variable?
if yes then apply advanced ref qualifier as this
Note: Use correct country field here from ESN table and also the variable name
javascript:'u_countryField=' + current.variables.countryVariableName;
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader