autocomplete best match

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
vismay 21 Jul, 2017
I use in read data the condition "model.filed/LIKE:%{data:name}%"
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.

VPS & Email Hosting 20% discount
hostinger