I'm been through the forums and some SQL references and can't quite get this to work. Not sure if it is my syntax or the structure of the data itself.
I want to allow users to search the address field of the parcels data set. I want them to be able to enter a partial address and then the search do a wild card.
Here is my latest version. If i search the entire value like in the example it returns the right record but not if i just type 46 or 46 CORNHILL or any sub variant. I have tried the different wildcard symbols % and * My data is just in a shapefile in the Arcmap document.
Any suggestions would be appreciated. I have tried many variants but can't seem to get it quite right. Thank you.
See below for the current definition in the esearch widget configuration.xml
<layer> <enableexport>true</enableexport> <name>Parcels</name> <url>http://preservationsearchwebgis.anth.umd.edu:8399/arcgis/rest/services/AIA_Basic_Web/MapServer/11</url> <expressions> <expression alias="Parcel Address" textsearchlabel="Search by Address [ Example: 46 CORNHILL STREET]:">Upper(ADDRESS) like Upper('[value]*')</expression> </expressions> <graphicalsearchlabel>Use one of the graphical search tools to select Archaeology Reports</graphicalsearchlabel> <spatialsearchlayer>true</spatialsearchlayer> <titlefield>Parcels</titlefield> <fields all="true"> </fields> <linkfield></linkfield>