AnsweredAssumed Answered

like operator in querytask

Question asked by Adityakumar529 on May 3, 2016
Latest reply on May 4, 2016 by Adityakumar529

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

Outcomes