topic Query doesnt return results if i dont use caps in ArcGIS JavaScript Maps SDK Questions

Query doesnt return results if i dont use caps

MatejSkerjanc — Mon, 10 Sep 2012 08:47:46 GMT

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?

Re: Query doesnt return results if i dont use caps

StephenLead — Mon, 10 Sep 2012 22:50:13 GMT

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.

Re: Query doesnt return results if i dont use caps

MatejSkerjanc — Tue, 11 Sep 2012 07:46:53 GMT

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.

It was me thinking it works like usual SQL server where it doesnt really matter if you type in lower case or upper case but i solved it using setting query task where to use LOWER. Thanks for the answer!