autocomplete best match

How to get autocomplete to show the best match first.

Overview

The autocomplete field returns results in an unexpected order, not prioritizing the closest match or alphabetical order.
Change the LIKE condition in the read data action from using wildcards on both sides to only at the end of the search term.

Answered
ChronoForms v6
vi vismay 21 Jul, 2017
Hello,

I have a Form with autocomplete from database.

There are thousands of cities and when I search something like "Nola" I would like that the first match is the best match: Nola.

But I don't even get an alphabetical order, even if I use modelname.fieldname/asc ( or field name/asc?) and the cities in database are alphabetically ordered.

See attachment.

Thanks
vi vismay 21 Jul, 2017
I use in read data the condition "model.filed/LIKE:%{data:name}%"
vi vismay 21 Jul, 2017
Answer
1 Likes
Looks like with a "model.filed/LIKE:{data:name}%" I get a better result....
This topic is locked and no more replies can be posted.