*****I'm not referring to DW not accepting a value in a select list only field that does not match the case of the value on the select list. I've seen other threads on this, but that is not my issue.******
I'm reffering to the in field search for a select list value being case sensitive. We have a vendor list of 13k names. Users may only know part of the name. Let's say the vendor name is BROOKLYN HEIGHTS PAINT. My user may type *brooklyn. For the past 6 years this would bring up the vendor mentioned, they would select that value (not what they typed to search for the value, they would select the value that is displayed from the select list).
However, I recently set up a new select list where typing *brooklyn to search for BROOKLYN does not work. When I inquired with DW, I'm being told the select list search was always case sensitive, even though it has never been for us in our experience.
Can someone clarify? The select list type for both the working select lists which are not case sensitive and the new one that only has a case sensitive lookup, is external. There is no difference in the config.
In the image below I am showing it working and not working.