Latest Contributions by JoelBennett

It appears the where clause is parsed and applied client-side, and if it doesn't support functions like UPPER and LOWER, then it doesn't appear the SDK can natively do what you want. However, it is possible to apply this kind of filtering by adding your own functionality to add conditions for every combination.  It's not pretty but it works, although I'm not sure what performance would be like as search values get longer and longer, since there would 2-to-the-power-of-x conditions where x is the number of characters in the input string. The following set of functions gets the job done: function addWordCombinations(word, index, partial, wordCombinations) { if (index < word.length) { addWordCombinations(word, index + 1, partial + word[index].toUpperCase(), wordCombinations); addWordCombinations(word, index + 1, partial + word[index].toLowerCase(), wordCombinations); } else wordCombinations.push(partial); } function getWordCombinations(word) { var wordCombinations = []; if ((typeof word == "string") && (word.length !== 0)) addWordCombinations(word, 0, "", wordCombinations); return wordCombinations; } function getCaseInsensitiveQueryConditions(fieldName, userValue) { var wordCombinations = getWordCombinations(userValue); if (wordCombinations.length === 0) return "1=0"; //query with this where clause would return no records else return "(" + fieldName + " LIKE '%" + wordCombinations.join("%' OR " + fieldName + " LIKE '%") + "%')"; }   With those in place, and assuming the user-specified search value was stored in a variable called "userValue" and the attribute field name was "name", you'd have something like: featureFilter.where = getCaseInsensitiveQueryConditions("name", userValue);   Note: this implementation assumes the user-specified search value doesn't contain apostrophes (i.e. single quotes).   Also, looking back after already typing up everything above, I notice you say you tried: (name LIKE UPPER('%hel%')) but have you tried: (LOWER(name) LIKE '%hel%')  If that works it would be so much simpler... ... View more

Yes, extending what @JoshuaBixby has already said, if you had the user-specified value stored in a variable called "userValue", then you'd have something like this: layer.definitionExpression = "LOWER(DESCRIPTION) LIKE '%" + userValue.toLowerCase() + "%'";   You might also need to add some additional logic to accommodate for the user value containing an apostrophe (i..e. single quotation) mark as well. ... View more

The 4.27 AMD implementation is esri/widgets/Directions; the 4.33 documentation is here, and although doesn't mention the AMD syntax, AMD is supported in 4.27 and should still be largely (if not completely) the same (that is, the properties and methods documented in 4.33 probably haven't changed much since 4.27). ... View more