Tweak Built-In Search from only "Contains" to "begins with" or "ends with"
When enabling a field as ''Searchable" there should be an option for “begins with”, “ends with”, etc,
Currently, it is defaulting to “contains” and the query that VertiGIS Studio sends looks like the following:
https://esri.ca/server/rest/services/Cadastral/ParcelsExternal/MapServer/0/query?f=pbf&where=lower(ADDRESS)%20like%20%27%25750%2017th%20street%25%27%20&outSR=26910&spatialRel=esriSpatialRelIntersects&geometryType=esriGeometryPolygon&inSR=26910
The column name is “ADDRESS” and, by default, VertiGIS Studio puts a ‘%’ around all the strings.
so
lower(ADDRESS) like '%750 17th street%'
At the very least, I would like to remove the first ‘%’ sign for “begins with”
-
Great idea. We're struggeling with the low performance of the Built-In Search compared to the HTML5 viewer, in particularly the auto-complete part. This would help make the queries faster. Another idea specifically for auto-complete: make the query search for distinct values.
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
1 commentaire