Get the tables joined to a feature layer

JFr87

Hi,

is there a way to determine which tables are joined to a feature layer using the ArcGIS Pro SDK for .NET? 

For example, I have a Feature Layer "Trees" joined to a Table "Trees_Metadata". I performed the join using the "Joins and Relates" => "Add Join..." function. How can I use the ArcGIS Pro SDK for .NET to find out retrospectively which table the "Trees" layer is joined to?

Thanks in advance

GKmieliauskas

Hi,

You need to start from FeatureLayer or StandaloneTable to get origin or joined table.

        protected override async void OnClick()
        {
            var map = MapView.Active.Map;
            if (map == null || map.Layers.Count == 0)
            {
                MessageBox.Show("No layers found in the map.");
                return;
            }

            var bfl = map.GetLayersAsFlattenedList().OfType<FeatureLayer>().FirstOrDefault(layer => layer.Name.Equals("your layer name"));

            if(bfl.HasJoins)
            {
                await QueuedTask.Run(() => {
                    var table1 = bfl.GetTable().GetJoin().GetOriginTable();
                    var table2 = bfl.GetTable().GetJoin().GetJoinedTable();
                    // your code here

                });  
            }
        }