topic Re: QUERYTASK and case sensitivity in ArcGIS JavaScript Maps SDK Questions

QUERYTASK and case sensitivity

StephenLead — Fri, 10 Dec 2021 22:05:31 GMT

What are the techniques recommended for handling case sensitivity in a query in the JS API?

The Query No Map sample is a perfect example - search on "CALIFORNIA" and it returns no results.

Is there a way to handle the situation where the user doesn't know the correct capitalisation required?

function execute(stateName) {
        query.text = stateName;
        queryTask.execute(query,showResults);
      }

You could convert query.text to upper- or lower-case, but that doesn't help unless the actual value in the geodatabase matches. Is there a flag to ignore the case in a query?

Thanks,
Steve

Re: QUERYTASK and case sensitivity

HemingZhu — Fri, 10 Dec 2021 22:05:34 GMT

What are the techniques recommended for handling case sensitivity in a query in the JS API?

The Query No Map sample is a perfect example - search on "CALIFORNIA" and it returns no results.

Is there a way to handle the situation where the user doesn't know the correct capitalisation required?
function execute(stateName) {
        query.text = stateName;
        queryTask.execute(query,showResults);
      }
You could convert query.text to upper- or lower-case, but that doesn't help unless the actual value in the geodatabase matches. Is there a flag to ignore the case in a query?

Thanks,
Steve

query.text, as API stated, is "Shorthand for a where clause using "like". The field used is the display field defined in the map document. You can determine what the display field is for a layer in Services Directory". Use query.where instead so that you could convert both end to upper case:

function execute(stateName) {
        query.where ="Upper(STATE_NAME) like '%" + stateName.toUpperCase() +"'%";
        queryTask.execute(query,showResults);
      }

Re: QUERYTASK and case sensitivity

StephenLead — Tue, 02 Aug 2011 00:19:58 GMT

query.where ="Upper(STATE_NAME) like '%" + stateName.toUpperCase() +"'%";

That works - thanks again.

Re: QUERYTASK and case sensitivity

StephenLead — Fri, 10 Dec 2021 22:05:37 GMT

query.where ="Upper(STATE_NAME) like '%" + stateName.toUpperCase() +"'%";

Just to add to this - using Upper() in the query seems to slow it down dramatically.

I found it much faster to convert the values to uppercase in the geodatabase (in an edit session within ArcMap), and simply use:

query.where ="STATE_NAME like '%" + stateName.toUpperCase() +"'%";

Steve

Re: QUERYTASK and case sensitivity

HemingZhu — Fri, 10 Dec 2021 22:05:40 GMT

Just to add to this - using Upper() in the query seems to slow it down dramatically.

I found it much faster to convert the values to uppercase in the geodatabase (in an edit session within ArcMap), and simply use:
query.where ="STATE_NAME like '%" + stateName.toUpperCase() +"'%";
Steve

Of cause. Basically you eleminate an extra SQL function UPPER().

Re: QUERYTASK and case sensitivity

KennethRichards — Mon, 09 Sep 2013 17:52:05 GMT

How would you write this if you wanted to query using a second attribute as well?

Re: QUERYTASK and case sensitivity

StephenLead — Fri, 10 Dec 2021 22:05:42 GMT

How would you write this if you wanted to query using a second attribute as well?

You could use something like:


query.where ="STATE_NAME like '%" + stateName.toUpperCase() +"'% AND SECOND_ATTRIBUTE like %" + secondValue.toUpperCase() + "%"

(I haven't verified that it all balances out, but the key thing is to use an AND statement in the URL query).