I'm trying to alter the query widget search expression to convert the input value to all upper case and the search input to all upper case. Even though there is a 'caseSensitive' parameter in the widget and it's set to false, my query will only work if using all caps.
For example, 935 2nd st sw will NOT work; while 935 2ND ST SW will work.
Below is a screenshot of the expression values I'm trying to get to work, but still don't.
Any input would be appreciated!
I was also able to do it in the Widget.js file of the Query Widget. Though this would force upper case on all queries submitted through the Query Widget, which works for us since we have all of our data in upper case. See lines 546 and 549.