idea Make Aggregation Query Layer — Indicate what table Unique Identifier Field is from in ArcGIS Pro Ideas

Make Aggregation Query Layer — Indicate what table Unique Identifier Field is from

Bud — Fri, 14 Jun 2024 14:30:20 GMT

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:

I'm using the Make Aggregation Query Layer tool to join from an FC to a table. Both items have an ObjectID field, as expected.

The Unique Identifier Field parameter seems to be mandatory. An ObjectID field is listed in the parameter picklist by default.

What item does the ObjectID field pertain to? The FC or the table? My best guess is the ObjectID field belongs to the FC (the Target Feature Class). But I am wondering if the tool could make it more obvious.

Related Esri Support cases:

03651040 Make Aggregation Query Layer - Target Feature Class "table not found" error
03651111 Make Aggregation Query Layer - ERROR 000840 Target Feature Class parameter
03651113 Make Aggregation Query Layer - Error 000358 No fields can be mapped to unique identifier

Re: Make Aggregation Query Layer — Indicate what table Unique Identifier Field is from

BBicking1 — Fri, 14 Jun 2024 17:08:42 GMT

Hello Bud,

the tool owner is notified.

Meanwhile, please review the following, also for the related support issues.

https://pro.arcgis.com/en/pro-app/3.3/help/mapping/layer-properties/display-features-with-aggregated-results.htm

https://pro.arcgis.com/en/pro-app/3.3/help/mapping/layer-properties/what-is-a-query-layer-.htm

https://pro.arcgis.com/en/pro-app/3.3/help/mapping/layer-properties/define-parameters-in-a-query-layer.htm

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/make-query-layer.htm

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/creating-a-query-layer.htm

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/choose-unique-identifier.htm

Please verify that two of the support issues reproduce in 3.3 and ensure that you have permission to access/use the .sde data.