We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Filter reference field based on another reference field in catalog item

Bindhu1
Tera Contributor

Hi , Kindly help me to achieve this .

Bindhu1_0-1707917078016.png

I have two reference field ,
1st field refers to u_building (which stores locations) and
2nd field refers to  u_cmdb_ci_server_virtual (stores VMs)
Based on location selected is first variable , 2nd variable should give VMs of that location 

Sample record of u_cmdb_ci_server_virtual (stores VMs)  with location refers to u_building (which stores locations)

Bindhu1_1-1707917549141.png

 



 

1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron

@Bindhu1 You should use the following reference qualifier on the second variable.Screenshot 2024-02-14 at 7.15.38 PM.png 

 

javascript&colon;'location='+current.variables.<first_variable_name>

 

Here replace <first_variable_name> with name of the first variable.

 

Hope this helps.

 

View solution in original post

4 REPLIES 4

Sandeep Rajput
Tera Patron

@Bindhu1 You should use the following reference qualifier on the second variable.Screenshot 2024-02-14 at 7.15.38 PM.png 

 

javascript&colon;'location='+current.variables.<first_variable_name>

 

Here replace <first_variable_name> with name of the first variable.

 

Hope this helps.

 

Thanks for replying , this filter giving all record, not sure where i am going wrong .tried with different filter

javascript&colon;'location='+current.variables.select_the_data_centre
javascript&colon;'location='+current.variables.select_the_data_centre.u_building_name

 

Hi @Sandeep Rajput , Thanks for your help. 
This is working with below filter

javascript&colon;"location="+current.variables.select_the_data_centre

 

Dr Atul G- LNG
Tera Patron

Hi @Bindhu1 

 

Dud you try with depend way like we have category and sub category?

*************************************************************************************************************
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]

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