Query doesnt return results if i dont use caps

MatejSkerjanc

I got a query widget and if i dont enter the search string in upper case it wont return results but will trigger an error.
I have almost identical application just different service and it works with lower case without a problem.
Is there something i'm missing?

StephenLead

if i dont enter the search string in upper case it wont return results but will trigger an error.
I have almost identical application just different service and it works with lower case without a problem.

It's likely that in one service, your values are stored in uppercase while in the other service, they are stored in lowercase. The query honours the case of the input features.

To test this, open your query URL in a web browser and append "/query" - this will bring up an interface allowing you to inspect the values of your fields. Eg:

http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/Earthquakes/Since_1970/MapServer/0/query

For example, this query reveals that the Name field is stored in uppercase:

 "Name" : "CHINA: YUNNAN PROVINCE; VIETNAM: HANOI"

You may be able to handle this in your code by converting the input string and the query to uppercase.