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?