Hosted Feature layer - Enforces lower case field names????

[AndrewBowne]

Are lower case field names enforced in a hosted feature layer?  I am trying to use all UPPER CASE field names (as I learned was the standard many many years ago) and the field keep defaulting to all lower. 

This is causing some issues in a custom app that we have which is looking for uppercase field names.

[ChristopherCounsell · Accepted solution]

The ArcGIS Data Store leverages PostgreSQL as an internal database. This only supports lower case field names.

All field names must be lowercase when publishing Hosted Feature Layers to ArcGIS Enterprise.

I don't have an enterprise documentation link but it's listed as a limitation in the Survey123/Enterprise documentation:

https://doc.arcgis.com/en/survey123/get-started/survey123withenterprise.htm#ESRI_SECTION1_F5A1901B74...

[AndrewBowne]

Thanks, Chris.  I had a a feeling that this might be the case.  I am just not very familiar with PostgreSQL.  It's an unfortunate limitation.

I looked everywhere and could not find any sort of documentation about the limitation.  Thanks for finding something (in a rather obscure place).

[GrahamWood-HWC]

Thanks Chris.

This was once classified as a bug but the archived enterprise doccos point out that this is a limitation of data store using PostgreSQL..
https://support.esri.com/en-us/bug/when-publishing-a-hosted-feature-service-to-portal-for-bug-000099...