Latest Contributions by RichRuh

Hi Than, I think you want to take a look at QueryDefs (ProConcepts Geodatabase · Esri/arcgis-pro-sdk Wiki · GitHub ).  This is another join construct in ArcGIS.  It works with datasets that come from the same geodatabase.   There are a lot of different query constructs available in the Pro SDK.  In addition to just a basic query on a single table using Table.Search, we support QueryDefs, Joins, QueryTables, and QueryLayers.  If the document above doesn't clarify the difference enough, my colleagues and I gave a session on the Geodatabase SDK at the (virtual) DevSummit this year: https://www.youtube.com/watch?v=EKx1kzQARlM&list=PLaPDDLTCmy4Ys8vfmC7DbX3FHSsyosvh7&index=151&t=0s   The section on Queries starts at 14:40. I hope this helps, --Rich ... View more

Hi, I've been talking to Renato and other Esri staff offline, and wanted to add some information. 1. As you know, we do not provide access to the fine-grained network topology on the client.  We've developed a detailed and flexible set of tracing configuration options to address the most common workflows, but we're no under no illusions that we've got them all covered. 2. You can use the Export Subnetwork geoprocessing tool to return the network connectivity for a subnetwork.  Depending on the workflows you are trying to accomplish, this might help. 3. Our documentation hints that this capability is available with Trace.  As Renato pointed out, this hasn't been implemented yet.  In the short term we're in the process of removing this from the doc, but it remains on our long-term roadmap. 4. Starting with ArcGIS Enterprise 10.8.1, the Enterprise SDK will allow access to utility network topology in a Server Object Extension (SOE).  You'll also need a way to call this SOE, either via directly calling a REST endpoint, or by writing a Server Object Interceptor (SOI). I hope this helps some. --Rich P.S. If you have more specific information about the business cases you are trying to solve we can investigate whether we could add the necessary options to our core product.   Here are some ideas for the cases you described above. * You should be able to use the Nearest Neighbor filter to return the two nearest devices of a particular type.  (You might need a second trace to find the nearest device so that you know the order of the devices.) * You might be able to use Functions to find voltage drop along a downstream path ... View more

If you post the schema of tables A and D, along with the geoprocessing command that you're using to create the relationship class, we can try to help you out.   You might have better luck however, if you post in the Geoprocessing‌ space rather than here in the SDK space. --Rich ... View more

Hi Sreeni, The geodatabase API doesn't allow schema changes (DDL).   To programmatically add attribute rules, you will have to either Write a Python script Execute geoprocessing tools using the geoprocessing API Here is an overview of the attribute rules toolset. I hope this helps, --Rich ... View more

Hi Michael, The GetOriginalValue method is used while editing to get the pre-edit value of the field.  You cannot edit a QueryDef, so this concept doesn't apply. You can just use the Item property. Since this is the default indexer on the Row class, you would change your provided code snippet to look like this: foreach (var field in fields) { if (field.FieldType == FieldType.Geometry) continue; // This works object val = row[field.Name]; // This works too int index = row.FindField(field.Name); object val = row[index]; } ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I hope this helps, --Rich ... View more

Adding DDL functionality is currently in design and is part of our long-term plan.  Unfortunately, I cannot yet provide any release date estimates. --Rich ... View more

Lars, That error message isn't clear at all.  The Geodatabase.Evaluate method uses a QueryDef object to create a virtual table.  QueryDefs can reference multiple tables, but the resulting virtual table cannot be edited.   Could you create your cursor by calling Table.Search() instead?  This uses what is called a QueryFilter, which can only reference a single table, and is editable.  This is the typical pattern used for editing data. --Rich ... View more