Reference field query

[joshmorris]

Currently, on this reference field when typing it shows results from the 'name' field. How can I get it so when i type it also brings back results from 'code' field. If that makes sense?

[Nilesh Pol · Accepted solution]

@joshmorris Usually this type of autocomplete search mostly works on display field i.e. name.

If you also want it to search by another field like Code, then you can use Attribute on reference field.

ref_ac_columns = code;  OR = code, name // shows both; 

ref_ac_columns_search = true;

[Nilesh Pol · Accepted solution]

@joshmorris Usually this type of autocomplete search mostly works on display field i.e. name.

If you also want it to search by another field like Code, then you can use Attribute on reference field.

ref_ac_columns = code;  OR = code, name // shows both; 

ref_ac_columns_search = true;

[Ankur Bawiskar · Accepted solution]

@joshmorris 

in the dictionary add this

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=code,ref_ac_columns_search=true,ref_ac_order_by=name

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

[Tanushree Maiti]

Hi @joshmorris 

Navigate to sys_dictionary.list in Application navigator

Search for your code field.

update following in the attribute field

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=code,ref_ac_columns_search=true

If you want sort the list based on your field,  append ref_ac_order_by=code   or ref_ac_order_by=name