QUERYTASK and case sensitivity

Question

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

StephenLead · Answer

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).

KennethRichards · Answer

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

HemingZhu · Answer

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().