Wappler 3.7.6
Windows 10pro
PHP
Mysql
the autocomplete field is filled I don’t know why, I would like it to come empty
I can’t understand where this value comes from
Well you have added a value to it, just remove this: dmx-bind:value="query.sel_geral"
Can you try changing this:
optiontext="bairro+', '+cidade+' - '+estado"
to some value which is only dynamic like optiontext="bairro" to test if this fixes it?
yes it works, more needed the 3 variables
I need to search for: neighborhood, city and state
isso funciona
optiontext="bairro"
But I need it like this
optiontext="bairro+', '+cidade+' - '+estado"
I always did it this way and it worked, what changed? @patrick
Hi Adriano, it seems that the property bairro is empty or null, cidade and estado seem to return values.
can you post a part of the recordset used for the autocomplete
Hello @patrick would that be?
https://wikihome.com.br/dmxConnect/api/autocomplete/auto_complete_filtro_imoveis.php
removing null or empty results worked 
1 Like
@patrick Does the autocomplete only work with all records or does it work with paginated queries?
I ask why it will get very heavy over time to load all the data
You should cache the results, so that the results are only retrieved once for each client. Paging will not work with the autocomplete.
An other option you often see with autocomplete components is that they send a request for each search action to the server and the server does the logic for filtering and only returns the filtered result. This is currently not possible with our autocomplete. This method helps when you have very large recordsets with thousands or millions of records. But I think with up to 10000 records it would be fine to just get it once and then reuse it on the client.
1 Like