Show 2 table data in 1 catalog item variable.

[fehbqhbi1]

I have a requirement for one of the catalog item variable where variable type is refecne field and its refer to core_company table and now i want to show case the company id which is related table of core_copany table named assumed core_company_id so the select option/dropdown should look like core_company [core_company_id]

[Tanushree Maiti]

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

[fehbqhbi1]

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]

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)

[fehbqhbi1]

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