Select to view content in your preferred language

Meaning of blue/purple text in query layer

252
1
07-19-2022 09:32 AM
Labels (1)
AmyRoust
Occasional Contributor III

In this ArcGIS Pro query layer, one of my field names turns blue/purple:

AmyRoust_0-1658248206991.png

When I publish the layer in a web service, it gets quotes around it:

AmyRoust_1-1658248268872.png


The quotes are causing issues with related tables. Why do they appear, and is there any way I can get rid of them? I've tried adding AS [Level] as an alias, but the quotes still appear in the service.

Tags (1)
0 Kudos
1 Reply
jcarlson
MVP Esteemed Contributor

In Oracle at least, "LEVEL" is a keyword. It would be like naming your column "INT" or something, and the publishing process probably just quotes it out to avoid messing up the queries going on with the database. Could you try an abbreviation like "lvl"?

- Josh Carlson
Kendall County GIS
0 Kudos