Alter query widget search expression

2778
2
03-30-2015 12:51 PM
mpboyle
Regular Contributor

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!

2 Replies
mpboyle
Regular Contributor

Solved...use the right string operator in the first place This will automatically place an UPPER operator on your entry and search field.

DrewSwayne
New Contributor II

Matthew,

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.

0 Kudos