How to enable autopopulate matching values when start typing

[sunil maddheshi]

Hello everyone!

I have a catalog item, where I have a reference field which is referring to a custom table, My issue is when i start typing in this field, it is not poping out matching values. Could you please help me, how to make this work> Here are some screenshots and variable attrubute i tried so far.

[TharaS657398130]

Hi

1. Go to system properties and check if glide.ui.ref_ac = true

2. In your variable attribute try adding : ref_auto_completer=AJAXTableCompleter

3. Check if read access ACL is enabled for your custom table

4. Open u_product and check if the index is set to true

Try putting some test records like Test1, Test2, Test3,.. and then in the field type Test and check

[sunil maddheshi]

Hi @Ankur Bawiskar , Just checked I saw for some values it is matching and it is showing the matching value but for some values it is  not working.

[TharaS657398130]

Okay.Your config is fine but the issue is with the search then

Try adding these in your value attributes

ref_auto_completer=AJAXTableCompleter
ref_ac_columns=u_product
ref_ac_columns_search=true

Also when you're searching put * (containts) and search if the issue persists

[sunil maddheshi]

@Ankur Bawiskar  @TharaS657398130 @VaishnaviK3009 
I see for some choices it is populating matching words but for some it is not populating, please see the screenshot.ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_product,ref_ac_columns_search=true

[TharaS657398130]

I am not able to see your screenshot idk why.. 

Go to dictionary - u_product field and set index=true