idea ArcGIS Aliases used in Query builder in ArcGIS Pro Ideas

ArcGIS Aliases used in Query builder

SusetteMartin4 — Tue, 23 Apr 2024 20:07:07 GMT

Would it be possible to use the Aliases values, that is setup under the Layer Properties, Fields tab, through out the system, e.g. when you use the query builder it would display the Alias name and not the field name?

Susette

Re: ArcGIS Aliases used in Query builder

DougYates1 — Fri, 04 Jun 2010 18:50:53 GMT

This would be nice but i would want it to allow either the alias or the true column name. Perhaps "NameFieldActual (Name)" in the UI. Then the UI would just choose one (I'd suggest the alias) to pass to the query. The query however would support either the real name or the alias.

Re: ArcGIS Aliases used in Query builder

WesleyMarcell — Tue, 13 Dec 2011 21:55:20 GMT

This would be a great addition. When joining a table to a feature layer you end up with extremely long field names which clutters code and makes everything more complex than it should be.

It would be much easier to build a query off of the alias "FieldName" vs what we are required to do now "Database.User.Tablename.FieldName" or "Database.User.FeatureClass.FieldName"

Would love to see this happen.

Re: ArcGIS Aliases used in Query builder

WesleyMarcell — Tue, 13 Dec 2011 21:57:41 GMT

Would be great. If you have ever built query's off of joined tables you know how something that should be simple gets complex very quickly.
Alias is much easier to script than "DatabaseName.UserName.Table/FeatureName.FieldName"

Re: ArcGIS Aliases used in Query builder - Status changed to: Already Offered

KoryKramer — Fri, 19 Feb 2021 18:16:14 GMT

I realize this is a very old idea, but I stumbled across it just now and figured I'd comment.

It is possible to switch between field name and alias in the query builders.

Examples: