AnsweredAssumed Answered

Portal Web Map Filter/Search Case Sensitivity

Question asked by ryanuthoff on Nov 6, 2018

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?

Outcomes