I am trying to modify the input value in the Enhanced Search Widget using SQL. I have tested the SQL expression in the ArcMap field calculator and it works but it fails inside the Enhanced Search Widget.
I have a field called MapTaxlot where the values have random spaces. Some of the values have 1, 2, o 3 spaces.
I want the users to be able to type the field value with spaces and modify the input value to eliminate the spaces and query a field where the values have no spaces.
The reason for this is because when we try to use field values with spaces the query fails.
The SQL query to eliminate the spaces is: replace([MapTaxlot]," ", "")
When I combine the above SQL query with the value input in the Enhanced Search Widget it doesn't return a result.
Here is my combined query:
<expression alias="Taxlot" textsearchlabel="Enter the taxlot number below"> <values> <value>Taxlot_Num like ('%replace([value," ", "")%')</value> </values> </expression>
I hope Robert or somebody else could give a clue about what is happening. Thank you.
