topic Portal Web Map Filter/Search Case Sensitivity in ArcGIS Enterprise Questions

Portal Web Map Filter/Search Case Sensitivity

RyanUthoff — Tue, 06 Nov 2018 21:48:55 GMT

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?

Re: Portal Web Map Filter/Search Case Sensitivity

JessicaNeuner1 — Wed, 16 Jan 2019 17:05:40 GMT

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.

Re: Portal Web Map Filter/Search Case Sensitivity

RyanUthoff — Thu, 17 Jan 2019 13:14:00 GMT

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.

Re: Portal Web Map Filter/Search Case Sensitivity

JessicaNeuner1 — Thu, 17 Jan 2019 23:14:25 GMT

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

Re: Portal Web Map Filter/Search Case Sensitivity

RyanUthoff — Fri, 18 Jan 2019 13:03:53 GMT

That's great to hear! Thank you for calling about it.