topic like operator in querytask in ArcGIS JavaScript Maps SDK Questions

like operator in querytask

ADITYAKUMAR1 — Tue, 03 May 2016 14:40:44 GMT

Hi Users,

I am performing Query task .

function execute(searchText, AssetSelected, SearchField) {

query.where = SearchField + " LIKE('" + searchText + "%')";

queryTaskQS.execute(query, showResultidentify);

}

I am passing all the query as SAMPLE(uppercase) but we do have some values which are not in uppercase

like "Sample", "SAmple","sample". In these cases the query is failing for me.

Is there any way where like operator wil work for all values "SAMPLE", "SAmple" ,"Sample" and "sample".

Thanks in advance

Regards

Aditya Kumar

RobertScheitlin__GISP — Tue, 03 May 2016 14:48:20 GMT

Aditya,

To make a case insensitive search you use a SQL string like this:

query.where = "Upper(" + SearchField + ") LIKE Upper('" + searchText + "%')";

ADITYAKUMAR1 — Wed, 04 May 2016 20:06:20 GMT

Thanks Robert, It worked fine.