autocomplete for list collector not working for all records in a custom table

[Les1]

version yokohama patch 10

catalog item variable is a list collector pointed to a custom table.

reference qualifier is pulling in the choice options  though not ordered alphabetically as desired.

autocomplete search will work for some records, notably those that are more recent or if i update a record then it is searchable, but all other records remain not searchable (just get "No matches found")

*i've also just found that this behavior occurs only in our DEV instance, in our TEST instance i'm not seeing the undesired behavior.

would like help or advice for if i should expect this to work and what i might try.

current var attributes: ref_auto_completer=AJAXTableCompleter

current ref qualifier:  

javascript: 'u_serviceISNOTEMPTY^u_active=true^u_bank='+current.variables.bank;

the result is that autocomplete only finds records that have been recently updated, other records seem to be ignored. 

[jasonutah]

Have you tried in an incognito tab to rule out a browser cache issue? Other than that you may want to check whether your dictionary on the custom table has display = true on the values. I've noticed those don't get moved between dev and test instances sometimes. Make sure display = true for columns.

[Les1]

thanks for your ideas

i just verified with incognito, no luck.

the display value is the same on the table in both environments. i've got the attribute display value to be the display = true as i need the calculated value.

it smells kinda like an indexing issue, as if i update a record then it becomes findable to autocomplete. 

[Santhana Rajhan]

Sometimes, the fields listed in the reference should also have a value. Eg. if im reference user table, and if email is selected as an attribute, empty ones will automatically be hidden. Check by adding name or any other fields which has values.

Add a field name 

Eg :

Attributes

no filter,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=name

or remove no filter

ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=name

If these dont work, try removing the attribute altogether and test.

current ref qualifier:

javascript:'u_serviceISNOTEMPTY^u_active=true^u_bank='+current.variables.bank;

[Les1]

Appreciate the response, i think i understand what you're suggesting, does that speak to that it was appearing that if a record had been updated recently verses an older record then it would get retrieved by autocomplete, the older records (of similar values) would not.

In any case, i'm unable to test further as i renewed the whole table (per client direction) and now seems to be working ok, i'll have to keep an eye on it going forward. 

thanks for trying to help me out, i'll have to wait and  see if the observed behavior happens again.