Help with Reference Qualifier – Search by Multiple Fields (Name, Code, Country)

[abhisheksat]

Hi everyone,

I have a catalog item that includes a reference field referencing the core_company table. By default, the lookup works fine when searching by the company name, but now my client wants to be able to search by company name, company code, and country.

I tried configuring the reference auto-completer as follows:

ref_auto_completer = AJAXTableCompleter
ref_ac_columns = name;u_company_code;u_country_ref
ref_ac_columns_search = true

However, this doesn’t seem to be working at all — it still only searches by the name field.

Has anyone successfully configured a reference field (especially in a catalog item) to search across multiple columns like this?
Any tips or examples would be greatly appreciated!

Thanks in advance!

[abhisheksat]

Yes, I have used the same but still I am not able to search with company code

[Ankur Bawiskar]

@abhisheksat 

did you try searching with **FCC

Does that company code have leading space in it?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[abhisheksat]

Yes, I did try that but still no Luck

[Ankur Bawiskar]

@abhisheksat 

try deleting the variable and create fresh one and see

[Muhammad Salar]

Hello @abhisheksat 

Try searching like that *FCC
May be there is any space in value