nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Server query

ShaningYu

I tested a query on a FC in ArcMap and the published mapservice layer in ArcGIS Server simultaneously. In ArcMap, the query is not case-sensitive. However, it is case sensitive in ArcGIS Server. Is there a way to set the query case-insensitive in the published service layer? Thanks.

Trouver plus de publications taguées avec

Accepted answers

kenbuja

You can search using Upper (or Lower) when querying a service. You have make sure what you're querying is in the expected case.

For example, I have a field name Comments that contains strings like "Coral" and "coral".

Both of these statements returns all expected records:

lower(Comments) like '%coral%'

upper(Comments) like '%CORAL%'

but this doesn't return any records

lower(Comments) like '%Coral%'

All comments

ChrisSergent

What is FC? And how are you trying to run the query in against the published service layer? Is it JavaScript? If so, you can use UCase in JavaScript to convert values to uppercase so that they match.

ShaningYu

FC = feature class. This FC is published as a mapservice layer. I'm using ESRI cmv project template. The serach function provided in that project is case-sensitive. I also posted a thread there: https://community.esri.com/message/546455#546455

Besides I also tested the query string: Upper(FName) like 'theValue'. It does not work.

ChrisSergent

Is your feature service public? And do you have an example expression that you are trying?

ShaningYu

Not public. I tested the query string:

(Upper)MON_TYPE LIKE 'theValue'

and

MON_TYPE LIKE Upper('theValue')

but neither works (see Search Tool - Case sensitive ). Thanks.

TanuHoque

FYI: case sensitivity in query depends on the underlying database and its settings. Clients like ArcMap or ArcGIS Server simply passes the sql where-clause to the underline database....

are you publishing by copying data on to the server and in that process the data gets copied to a different type of database? that may explain why it works in ArcMap but not on ArcGIS Server.

ShaningYu

It is OK on ArcGIS Server query. My real prolem is in https://community.esri.com/message/546456#546456 I haven't found the solution for the query string in CMV JS application. Thanks.

TanuHoque

the link you put in your reply takes brings me back to this thread... can you please check the link?

ShaningYu

Sorry. Should be Search Tool - Case sensitive

DavidParsons1

Just be sure to check .. on *very large* record sets .

by using constructs like this :-

lower(Comments) like '%coral%'

upper(Comments) like '%CORAL%'

you may prevent the underlying database from using any indexes on, in this case, the 'Comments' column. The index may be case sensitive, and as soon as the DB sees a function applied to column in may not be able to rely on the index and so will often ignore it, forcing a full table scan and causing a potential performance hit.

May not apply in your case .. just a heads up

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.