topic Re: How to get object id for the Query Layer in ArcGIS Pro SDK Questions

How to get object id for the Query Layer

trushar — Fri, 26 Jan 2024 19:42:44 GMT

Hello everyone, I am need of your assistance.

I am unable to get object id for the Query Layer. I can get it for shapefile or sde feature class.
Please take a look at the sample code below.

Thank you,
Trushar Mistry

//-------------------------------------------------- // trusharm 2024-01-04 4:37pm, query layer GetDefinition() throws // exception so we are unable to get field names, hence we cannot // query layer at the moment until Esri fixes the issue [NotNull] private static string GetIdFieldForSpatialView([NotNull] FeatureLayer selectedFeatureLayer) => ((CIMSqlQueryDataConnection)selectedFeatureLayer.GetDataConnection()) .OIDFields .Contains("OBJECTID", StringComparison.InvariantCulture) ? "OBJECTID" : throw new InvalidOperationException("The view must at least have OBJECTID as unique index");

Re: How to get object id for the Query Layer

GKmieliauskas — Fri, 26 Jan 2024 20:35:46 GMT

I would recommend you to check selectedFeatureLayer for OID type field using code below:

var fieldDescriptions = selectedFeatureLayer.GetFieldDescriptions(); var oidField = fieldDescriptions.Find(x => x.Type == FieldType.OID); if(oidField != null) { var oidName = oidField.Name; }

Re: How to get object id for the Query Layer

trushar — Mon, 29 Jan 2024 16:59:32 GMT

Thank you for your example @GKmieliauskas!

Apologies, I posted the question in rush and did not explain correctly nor did I copy the correct code sample.

Here is the core issue that I was attempting to get help on. I need access to column names and data under it so I can further bind it to my UI:

using var table = (selectedFeatureLayer.GetDataConnection() is CIMSqlQueryDataConnection { WorkspaceFactory: WorkspaceFactory.SDE }) ? selectedFeatureLayer.GetTable() : throw new InvalidOperationException("..."); var field in table.GetDefinition().GetFields()

The `GetDefinition()` fails for me for layer type `CIMSqlQueryDataConnection`. The exception is coming from `ArcGIS.Core.Data.GetDefinitionHandle()`. Is it possible there is an alternate way to get field names for query layers, would you happen to know?

Thank you again for your time,
Trushar M

Re: How to get object id for the Query Layer

GKmieliauskas — Tue, 30 Jan 2024 16:49:07 GMT

Could you please specify more information about ArcGIS Pro version and database type? There are some issues with GetDefinition method in ArcGIS Pro 3.2 and PostgreSql database. More info here.

Re: How to get object id for the Query Layer

trushar — Wed, 31 Jan 2024 21:10:17 GMT

Thank you for the link, I noticed DaveFullerton is running into same issue.
I am using ArcGIS Pro 3.2.1 and I am connected to SqlServer 2016.

Do I open a bug ticket with Esri?

Thanks,
Trushar