Tweak Built-In Search from only "Contains" to "begins with" or "ends with"

Gordon Luckett

17 Februari 2026 13:48

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”

1

• 

  Yannick Mijnheer

  19 Februari 2026 08:00

  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

Du måste logga in om du vill lämna en kommentar.