@fehbqhbi1 

but core_company_id extends from core_company then why not make your variable refer to this new table?

what's your actual business requirement here?

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Tanushree Maiti
Tera Patron

Hi @fehbqhbi1 

 

 

  • Navigate to your Service Catalog Item 
  • Open the specific Reference Variable.

 

  • Ensure the Reference field is set to core_company
  • Update Variable Attributes

 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=core_company_id,ref_ac_columns_search=true,ref_ac_display_value=true

 

Note: Assuming  core_company_id is field of Core_company

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti

these are 2 tables actually so i want to combine the field and showcase in one catalog item variable like this
company_name[company_id]

Aditya_hublikar
Mega Sage

Hello @fehbqhbi1 ,

 

Even you created database view for this requirement , in display value you will get only 1 field not concatenated one .(database view as reference table will work only for catalog variable not normal table field)

 

Aditya_hublikar_0-1781601264365.png

 

Aditya_hublikar_1-1781601299996.png

 

 

i guess this works for me can you please share the step to re porduce same