idea Query Layers: Show Field Properties in ArcGIS Pro Ideas

Query Layers: Show Field Properties

AlfredBaldenweck — Tue, 05 Sep 2023 17:11:23 GMT

On 2.9

For reference: Query Layers: View fields and field properties - Esri Community

I want to be able to see field properties in query layers.

The option is currently greyed out, meaning that I have to go back to the source table(s) to figure out (for example) if that number column is actually numbers or text. Ditto to view domains.

Re: Query Layers: Show Field Properties

Bud — Tue, 19 Sep 2023 18:16:29 GMT

To prove this point, we are able to see the field properties of database views in ArcGIS Pro (2.6.8):

Query layers and database views are normally treated similarly in ArcGIS Pro. So, like you, I would have expected the Fields view to work for query layers, just like database views.

As a last-resort workaround, I suppose you could temporarily create a database view from the query layer SQL, take a look at the Fields properties of the database view, and then delete the database view. That's pretty ugly though.

Re: Query Layers: Show Field Properties

AlfredBaldenweck — Thu, 18 Jul 2024 05:25:34 GMT

So, at UC today I asked about this and it looks like our not being able to see the fields of a Query Layer from the Hamburger menu in the attribute table is a bug of some sort; you can view the fields if you to the Data tab, for example.

Hopefully this should get fixed!

Re: Query Layers: Show Field Properties

Bud — Thu, 18 Jul 2024 12:25:42 GMT

@AlfredBaldenweck Interesting. Would it help to submit a case to support to get a bug report created?

Re: Query Layers: Show Field Properties

AlfredBaldenweck — Sat, 20 Jul 2024 10:06:15 GMT

I did at UC, so hopefully I’ll get a phone call in the next week or two! The good news is that while I was explaining to Esri staff prior to filing a support case, we were able to replicate the issue in 3.3