I have recently changed the data source for some of the web maps I have on Portal from Microsoft SQL Server to PostgreSQL.
What comes along with this is Microsoft SQL is not case sensitive, while PostgreSQL is case sensitive. While I can take case sensitivity into consideration in ArcMap when searching by attribute (such as using LOWER(field name)), I do not know of a way to do this through Portal web maps when filtering by attributes.
I have end users that would like to be able to filter, but don't necessarily know the case of the letters when filtering. Is there a way to use UPPER/LOWER functions in the Portal web maps like in ArcMap when selecting by attribute? Or any other method of searching by attribute without it being case sensitive?
We noticed similar behavior with filters in the web map, in our case using the ArcGIS Data Store (which i believe is also PostgreSQL). Super confusing for our users when they get different result sets with "cost" vs "Cost".
We're on 10.6.1 here.
I'm glad I'm not the only one experiencing this. I would really like a way for users to be able to search non-case-sensitive words in the web map.
Hi Ryan -- I wound up reaching out to technical support about this issue and they submitted a bug! here's the reference: BUG-000119443 : Queries on services in Portal for ArcGIS are case sensitive
That's great to hear! Thank you for calling about it.