topic Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET in .NET Maps SDK Questions

Retrieve records from related table in ArcGIS Runtime SDK for .NET

MiriEshel — Tue, 25 Jul 2017 14:01:56 GMT

Hi everybody,
We are using ArcGIS Runtime 100.1 and we want to retrieve records from a related table in a FeatureService.
We are able to perform QueryRelatedFeaturesAsync and get the number of features by using NumberOfFeatures but we cannot find any method/property to retrieve the data itself.
Here is the code we are using:
// Select the features based on query parameters defined above
var selectedFeatures = await idLayer.SelectFeaturesAsync(queryParams, Esri.ArcGISRuntime.Mapping.SelectionMode.New);
var feature = selectedFeatures.First() as ArcGISFeature;
var relatedResult = await table.QueryRelatedFeaturesAsync(feature);
var relatedTbl = relatedResult[0].RelatedTable;
var num = relatedTbl.NumberOfFeatures;
What next??
Thanks a lot,
Miri

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

JenniferNery — Sat, 11 Dec 2021 10:27:21 GMT

I'll answer your question with a sample. The basic idea is related tables all participate in the same map - whether it is another layer or a non-spatial table. You can get to the feature by identify/query. Once you have a feature, query its related features by either specifying specific relationship or getting all regardless of source.

        xmlns:esri="http://schemas.esri.com/arcgis/runtime/2013"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <Grid.ColumnDefinitions>
            <ColumnDefinition />
            <ColumnDefinition />
        </Grid.ColumnDefinitions>
        <esri:MapView x:Name="MyMapView" />
        <TreeView x:Name="Result" Grid.Column="1" >
            <TreeView.ItemTemplate>
                <HierarchicalDataTemplate  ItemsSource="{Binding}">
                    <TextBlock Text="{Binding RelatedTable.TableName}" />
                    <HierarchicalDataTemplate.ItemTemplate>
                        <DataTemplate>
                            <ItemsControl ItemsSource="{Binding Attributes}"
                                          Grid.Column="1">
                                <ItemsControl.ItemTemplate>
                                    <DataTemplate>
                                        <Grid>
                                            <Grid.ColumnDefinitions>
                                                <ColumnDefinition />
                                                <ColumnDefinition />
                                            </Grid.ColumnDefinitions>
                                            <TextBlock Text="{Binding Key, StringFormat={}{0} :}" />
                                            <TextBlock Text="{Binding Value, StringFormat={} {0}}"
                                                       Grid.Column="1" />
                                        </Grid>
                                    </DataTemplate>
                                </ItemsControl.ItemTemplate>
                            </ItemsControl>
                        </DataTemplate>
                    </HierarchicalDataTemplate.ItemTemplate>
                </HierarchicalDataTemplate>
            </TreeView.ItemTemplate>
        </TreeView>
    </Grid>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

            MyMapView.GeoViewTapped += MyMapView_GeoViewTapped;
            MyMapView.Map = new Map(Basemap.CreateTopographic());
            MyMapView.Map.OperationalLayers.Add(new FeatureLayer(new Uri("https://services2.arcgis.com/ZQgQTuoyBrtmoGdP/ArcGIS/rest/services/AlaskaNationalParksPreservesSpecies_List/FeatureServer/1")));
            MyMapView.Map.OperationalLayers.Add(new FeatureLayer(new Uri("https://services2.arcgis.com/ZQgQTuoyBrtmoGdP/ArcGIS/rest/services/AlaskaNationalParksPreservesSpecies_List/FeatureServer/0")));
            MyMapView.Map.Tables.Add(new ServiceFeatureTable(new Uri("https://services2.arcgis.com/ZQgQTuoyBrtmoGdP/ArcGIS/rest/services/AlaskaNationalParksPreservesSpecies_List/FeatureServer/2")));

            MyMapView.Map.InitialViewpoint = new Viewpoint(new Envelope(-17677159.6926513, 7932123.08666798, -16355129.8191665, 9451936.95697339, SpatialReferences.WebMercator));
        }

        private async void MyMapView_GeoViewTapped(object sender, GeoViewInputEventArgs e)
        {
            var result = await MyMapView.IdentifyLayersAsync(e.Position, 2, false);
            foreach (var identifyResult in result)
            {
                if (identifyResult.LayerContent is FeatureLayer && ((FeatureLayer)identifyResult.LayerContent).FeatureTable is ArcGISFeatureTable)
                {

                    var table = (ArcGISFeatureTable)((FeatureLayer)identifyResult.LayerContent).FeatureTable;
                    foreach (ArcGISFeature feature in identifyResult.GeoElements)
                    {
                        var queryResults = await table.QueryRelatedFeaturesAsync(feature);                        
                        Result.ItemsSource = queryResults.ToArray();
                    }
                }
            }
        }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

MiriEshel — Thu, 27 Jul 2017 05:40:08 GMT

Hi Jennifer,

Thanks. It helped! We missed on ToArray() method.

Thanks again!

Miri

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Thu, 14 Sep 2017 13:36:01 GMT

Jennifer, thanks for the sample, but I'm a bit confused on how to actually implement what I need.

What I'm looking to do is actually be able to get the related features, and I expected the RelatedFeatureQueryResult.Feature property to be the related feature, but it is the original feature used to query the related records.

For example, I have owner data (point), which is related to a parcel (polygon), which is related to property data (table).

I get the owner data when a point is clicked on the map, so I have that feature. That is used to call QueryRelatedFeaturesAsync. What I want to be able to do is iterate the collection of RelatedFeatureQueryResult objects and get the property data, but I can't quite seem to figure out how to get the parcel feature object from this collection, so I can then get all of the records that are related to the parcel.

Any help would be appreciated, thanks.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Sat, 16 Sep 2017 15:24:31 GMT

Jennifer, do you have a sample that works on iOS/Android/UWP?

I don't see that the RelatedFeatureQueryResult is a feature set, so not quite sure how to get to the feature/attributes in that collection.

Thanks.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

JenniferNery — Sat, 11 Dec 2021 10:27:23 GMT

Hi, I'm sorry for the delay in reply. The IReadOnlyList<RelatedFeatureQueryResult>, result object from awaiting QueryRelatedFeaturesAsync, is a collection of iterator of features. In any platform, you can do something like this to access the related features and their attributes. In the original sample Result is a TreeView and individual template binds to table name and feature attributes.

var queryResults = await table.QueryRelatedFeaturesAsync(feature);
var resultCollection = queryResults.ToArray();
foreach (var queryResult in resultCollection)
{
    foreach(var f in queryResult)
    {
        var sft = (ServiceFeatureTable)f.FeatureTable;
        var id = (long)f.Attributes[sft.ObjectIdField];
    }
}‍‍‍‍‍‍‍‍‍‍

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Wed, 20 Sep 2017 18:09:06 GMT

Thanks Jennifer, I managed to get this working with the help of minerjoe.

I didn't realize it was a collection within the collection, but I'm pleased that it is now working.

Thanks again.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Fri, 22 Sep 2017 13:47:07 GMT

Jennifer, I'm finding that QueryRelatedFeaturesAsync() is not working with an offline database, at least one that is created as runtime content using ArcMap.

What are the requirements for the offline geodatabase to contain relationships? Do it need to come from Pro?

I'll try an offline replica next, and post back my results.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Fri, 22 Sep 2017 14:13:00 GMT

Quick update: using an offline replica geodatabase works, just not a runtime content geodatabase (ArcMap, 10.4).

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Fri, 22 Sep 2017 17:32:52 GMT

MMPKs work as well, so it's just runtime content that relationships don't appear to be working.

The RelationshipInfos are there, but a call to QueryRelatedFeaturesAsync returns nothing.

Is this a bug or just not supported?

Thanks.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

NagmaYasmin — Fri, 22 Sep 2017 17:55:13 GMT

Hi Chad,

I found a bug that is related with your issue but logged against Android 100.1. I believe you are seeing the same issue with .Net 100.1 as well. Below is the bug:

[BUG-000106463: GeodatabaseFeatureTable.queryRelatedFeaturesAsync does not return the related records when using ArcGIS Runtime SDK for Android 100.1.0. ]

Best,

Nagma

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Fri, 22 Sep 2017 17:58:47 GMT

Thanks, we're using Xamarin, so this impacts iOS, Android and UWP.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

JenniferNery — Fri, 22 Sep 2017 21:55:47 GMT

Hi Chad,

The workflow you mentioned, consuming runtime content from ArcMap, should have also worked. I just checked that the issue Nagma referenced had something to do with related tables not participating in the same map which is why no related features were returned. This is a requirement per https://developers.arcgis.com/net/latest/wpf/api-reference//html/M_Esri_ArcGISRuntime_Data_ArcGISFeatureTable_QueryRelatedFeaturesAsync.htm.

Are your related tables all part of the same map?

Thanks.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Sat, 23 Sep 2017 12:24:44 GMT

Yes, all of the tables (2 feature layers and 1 table) are all part of the same map.

The relationship infos exist, but using QueryRelatedFeaturesAsync doesn't return any records.

I could share the geodatabase if that helps, but it's nothing complicated, just some parcel data I downloaded from the web for development and testing purposes.

Thanks.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

JenniferNery — Mon, 25 Sep 2017 16:16:13 GMT

Sure that will be helpful, thanks! We will investigate, it sounds like a different issue then.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Mon, 25 Sep 2017 18:17:54 GMT

Thanks, I shared to geodatabase with you via Dropbox. Let me know if you don't get it.

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

JenniferNery — Sat, 11 Dec 2021 10:27:26 GMT

Thanks, Chad for the geodatabase. I'm unable to repro with v100.1. It seems like the first relationship reports no related features and the rest of the tables have at least one related feature. Is this what you'd expect with your data?

I used the following code.. similar code for Xamarin Android, slight differences would be namespace how you retrieve file path and display alert messages.

public MainWindow()
{
    InitializeComponent();
    MyMapView.Map = new Map(Basemap.CreateTopographic());
    MyMapView.LayerViewStateChanged += OnLayerViewStateChanged;
    MyMapView.GeoViewTapped += OnGeoViewTapped;
}

private async void OnGeoViewTapped(object sender, GeoViewInputEventArgs e)
{
    try
    {
        var results = await MyMapView.IdentifyLayersAsync(e.Position, 2, false);
        var layerResult = results?.FirstOrDefault(f =>
        f.LayerContent is FeatureLayer &&
        ((FeatureLayer)f.LayerContent).FeatureTable is ArcGISFeatureTable &&
        f.GeoElements.Any());
        if (layerResult == null)
            return;
        var layer = (FeatureLayer)layerResult.LayerContent;
        var table = (ArcGISFeatureTable)layer.FeatureTable;
        var feature = (ArcGISFeature)layerResult.GeoElements.FirstOrDefault();
        var queryResults = await table.QueryRelatedFeaturesAsync(feature);
        foreach (var r in queryResults.ToArray())
        {
            MessageBox.Show($"Feature with ID `{feature.Attributes[table.ObjectIdField]}` has `{r.Count()}` related features from `{r.RelatedTable.TableName}`.");
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().Name);
    }
}

private void OnLayerViewStateChanged(object sender, LayerViewStateChangedEventArgs e)
{
    var error = e.LayerViewState.Error ?? e.Layer.LoadError;
    if (error != null)
        MessageBox.Show(error.Message, error.GetType().Name);
}

private async void OnLoad(object sender, RoutedEventArgs e)
{
    try
    {
        var geodatabase = await Geodatabase.OpenAsync(@"E:\dev\palmbeach.geodatabase");
        var extent = geodatabase.GenerateGeodatabaseExtent as Envelope;
        foreach(var table in geodatabase.GeodatabaseFeatureTables)
        {
            await table.LoadAsync();
            if (table.HasGeometry)
            {
                if (extent == null || extent.IsEmpty)
                    extent = table.Extent;
                else
                    extent = GeometryEngine.CombineExtents(extent, table.Extent);
                MyMapView.Map.OperationalLayers.Add(new FeatureLayer(table));
            }
            else
                MyMapView.Map.Tables.Add(table);
            if (extent != null && !extent.IsEmpty)
                await MyMapView.SetViewpointAsync(new Viewpoint(extent));
        }
    }
    catch(Exception ex)
    {
        MessageBox.Show(ex.Message, ex.GetType().Name);
    }
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Tue, 26 Sep 2017 20:23:29 GMT

Thanks Jennifer, the results seem correct, but it is different from what I'm seeing.

Was your test with WPF or UWP?

I have not tried in UWP, but Android and iOS were not showing the relationships.

I can easily plug in your code into these platforms and see what I get. I'll report back once I have a chance to test.

Thanks!

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

ChadYoder1 — Tue, 26 Sep 2017 21:15:18 GMT

Jennifer, I have to apologize, I see that your code is in fact working in iOS and Android, so something is not right in my code/logic.

I'll continue to compare and get this figured out.

Again, I apologize for wasting your time, and certainly appreciate your help.

Thanks!!

Re: Retrieve records from related table in ArcGIS Runtime SDK for .NET

JenniferNery — Tue, 26 Sep 2017 21:21:19 GMT

No problem at all. It wasn't a waste of time. You actively checked other ways to create geodatabase and query related features and those were very good feedback. I'm glad it's working for you too.