Populate reference values based on user search

[Shwetha Nair]

Hi Developers!

We are having a requirement to add meta tags to the reference values so that whenever user searches with keyword the related values populate in reference field.

Meaning, We have a reference field Application referencing to cmdb_ci table which has certain filter put on it. Now when user tries searching with excel , it does not show up any values but if user puts Microsoft excel the he/she is able to select the value. So the requirement is , even if user searches with MS / excel then also this Microsoft Excel should show up in the reference field for selection.

Is there a possibility to do so?

Thanks in advance,

Fellow developer 🙂

[Sandeep Rajput]

@Shwetha Nair Looks like the additional column can't be hidden if it is included in ref_ac_columns. 

[Shwetha Nair · Accepted solution]

After some trial and error, I was able to display values only from the name field yet filtering the results using both from name and meta tag coloumn from the referenced field 

Ref qualifier : ref_auto_completer=AJAXReferenceCompleter,ref_ac_columns=u_meta_tag,ref_ac_columns_search=true,ref_ac_display_value=false