topic Re: Please help with ExecuteRelationshipQueryAsync in ArcGIS API for Silverlight Questions

Please help with ExecuteRelationshipQueryAsync

RickHendrickson — Thu, 07 Oct 2010 22:37:02 GMT

I can't figure out how to get the results from the related table. Using the query task I can get all the graphics and fields I want by basically using the the spatial query sample found here: http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#SpatialQuery

What is the proper way to get the related table information through the spatial query? For the 'regular query' I think you pass in the geometry from the draw surface. How does the relationshipquery work?

I'm desperate, Thanks!

Rick

Re: Please help with ExecuteRelationshipQueryAsync

JenniferNery — Sun, 12 Dec 2021 04:06:32 GMT

In the code-snippet below,
incidentsLayer is the FeatureLayer displayed on my map http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/0;
graphic is a feature in my incidentsLayer;
"agree_with_incident" is a field in the related table http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/1;
voteCount is the value I need to update based on the result of my query.

        private void QueryRelatedTable()
        {
            int objectId = Convert.ToInt32(graphic.Attributes[incidentsLayer.LayerInfo.ObjectIdField]);
            int relationshipId = -1;
            foreach (var relationship in incidentsLayer.LayerInfo.Relationships)
            {
                relationshipId = relationship.RelatedTableId;
                break;
            }
            QueryTask qt = new QueryTask(incidentsLayer.Url);
   qt.DisableClientCaching = true;
            RelationshipParameter rp = new RelationshipParameter();
            rp.ObjectIds = new int[]{objectId};
            rp.OutFields = new string[]{"agree_with_incident"};
            rp.RelationshipId = relationshipId;         
            qt.ExecuteRelationshipQueryCompleted += qt_ExecuteRelationshipQueryCompleted;            
            qt.ExecuteRelationshipQueryAsync(rp);
        }

        private void qt_ExecuteRelationshipQueryCompleted(object sender, RelationshipEventArgs e)
        {
            RelationshipResult pr = e.Result;
            voteCount = 0;
            foreach (var item in pr.RelatedRecordsGroup)
            {
                voteCount = item.Value.Count();
                break;
            }              
        }

Re: Please help with ExecuteRelationshipQueryAsync

RickHendrickson — Fri, 08 Oct 2010 15:03:47 GMT

Thanks Jennifer. I am giving this a shot now. I'll let you know how it goes.
Rick

Re: Please help with ExecuteRelationshipQueryAsync

RickHendrickson — Sun, 12 Dec 2021 04:06:34 GMT

I think I am close but not quite there. Can you please take a look at my code here and give me some advice?

How I want this to work is for the user to select a line on the map and then view a list of drawings associated with the line. It is a one to many relationship thus the reason for the related table. So I have it setup right now so I can select a line and view the data in the primary table. This first bit of code is the handler for the query:

Private Sub QueryTaskab_ExecuteCompleted(ByVal sender As Object, ByVal args As ESRI.ArcGIS.Client.Tasks.QueryEventArgs)
        Dim featureSet As FeatureSet = args.FeatureSet

        If featureSet Is Nothing OrElse featureSet.Features.Count < 1 Then
            MessageBox.Show("No features retured from query")
            Return
        End If

        Dim graphicsLayer As GraphicsLayer = TryCast(MyMap.Layers("MySelectionGraphicsLayer"), GraphicsLayer)

        If featureSet IsNot Nothing AndAlso featureSet.Features.Count > 0 Then
            For Each feature As Graphic In featureSet.Features
                feature.Symbol = TryCast(LayoutRoot.Resources("ResultsFillSymbol"), Symbol)
                graphicsLayer.Graphics.Insert(0, feature)
            Next feature
            ResultsDisplay.Visibility = Visibility.Visible
        End If
        MyDrawSurface.IsEnabled = False



        Dim objectid As Integer = Convert.ToInt32(featureSet.ObjectIdFieldName)
               Dim queryTaskab As New QueryTask("http://...../ArcGIS/rest/services/10106734/_AsBuiltRelate10/MapServer/0")

        AddHandler queryTaskab.Failed, AddressOf QueryTaskab_Failed

        AddHandler queryTaskab.ExecuteRelationshipQueryCompleted, AddressOf QueryTaskab_ExecuteRelationshipQueryCompleted

        Dim rquery As RelationshipParameter = New ESRI.ArcGIS.Client.Tasks.RelationshipParameter()
        rquery.ObjectIds = New Integer() {objectid}

        Dim outList As New List(Of String)
        outList.Add("OBJECTID")
        outList.Add("REDBOOKNUM")
        rquery.RelationshipId = 0
        rquery.OutFields = outList
        queryTaskab.ExecuteRelationshipQueryAsync(rquery)
    End Sub

The second half of that code is where I am setting up the relationship query. Having trouble passing in the objectids I think.

Thanks
Rick

Re: Please help with ExecuteRelationshipQueryAsync

DeraldDudley — Wed, 24 Nov 2010 10:50:25 GMT

Rick,

Did you ever figure this out. I'm have the same problem passing the objectIDs to the RelationshipParameters object.

Cheers,
Derald

Re: Please help with ExecuteRelationshipQueryAsync

JenniferNery — Sun, 12 Dec 2021 04:06:37 GMT

I think in the code that you posted, you are having problem with this line

Dim objectid As Integer = Convert.ToInt32(featureSet.ObjectIdFieldName)

The ObjectIdField property is the key to the attribute dictionary.
http://help.arcgis.com/en/webapi/silverlight/apiref/ESRI.ArcGIS.Client~ESRI.ArcGIS.Client.FeatureService.FeatureLayerInfo~ObjectIdField.html
What you need to convert to an integer is the attribute value for that key, the actual object id.

In the code I posted earlier, this is the VB version; where incidentLayer is a FeatureLayer:

Dim objectId As Integer = Convert.ToInt32(graphic.Attributes(incidentsLayer.LayerInfo.ObjectIdField))

I used a FeatureLayer to get LayerInfo and ObjectIdField. I did not want to hardcode the key used to get the object id. http://help.arcgis.com/en/webapi/silverlight/apiref/ESRI.ArcGIS.Client~ESRI.ArcGIS.Client.FeatureService.FeatureLayerInfo_members.html
You need not do the same thing, you can hardcode the key if you want, but you cannot convert the key to an integer. You need to get the value first and then convert 🙂

Re: Please help with ExecuteRelationshipQueryAsync

DeraldDudley — Sun, 12 Dec 2021 04:06:40 GMT

Here was my solution. Ill try yours next. Thanks! 😉

Private Sub Query_ExecuteCompleted(ByVal sender As Object, ByVal queryArgs As QueryEventArgs)
    If queryArgs.FeatureSet Is Nothing Then
      Return
    End If

    Dim resultFeatureSet As FeatureSet = queryArgs.FeatureSet

    Dim graphicsLayer As ESRI.ArcGIS.Client.GraphicsLayer = TryCast(Map1.Layers("Institutions"), ESRI.ArcGIS.Client.GraphicsLayer)

    If resultFeatureSet IsNot Nothing AndAlso resultFeatureSet.Features.Count > 0 Then
      For Each graphicFeature As ESRI.ArcGIS.Client.Graphic In resultFeatureSet.Features
        graphicsLayer.Graphics.Add(graphicFeature)

      Next graphicFeature

      Dim expandPercentage As Double = 30

      Dim widthExpand As Double = graphicsLayer.FullExtent.Width * (expandPercentage / 100)
      Dim heightExpand As Double = graphicsLayer.FullExtent.Height * (expandPercentage / 100)

      Dim displayExtent As New  _
      ESRI.ArcGIS.Client.Geometry.Envelope(graphicsLayer.FullExtent.XMin - (widthExpand / 2), _
                                           graphicsLayer.FullExtent.YMin - (heightExpand / 2), _
                                           graphicsLayer.FullExtent.XMax + (widthExpand / 2), _
                                           graphicsLayer.FullExtent.YMax + (heightExpand / 2))
      Map1.ZoomTo(displayExtent)
    End If

    RelatedQuery(resultFeatureSet)

  End Sub

  Private Sub RelatedQuery(ByVal resultsFS As FeatureSet)

    Dim qtRelatedTables As New QueryTask("http://204.68.195.113/ArcGIS/rest/services/DOTResearch/DOTResearchGDB/MapServer/4")
    AddHandler qtRelatedTables.Failed, AddressOf qtRelatedTables_Failed
    AddHandler qtRelatedTables.ExecuteRelationshipQueryCompleted, AddressOf qtRelatedTables_ExecuteRelationshipQueryCompleted

    Dim listObjIds As New List(Of Integer)
    Dim intIndex As Integer = 0
    For Each Feat In resultsFS.Features
      listObjIds.Add(resultsFS.Features(intIndex).Attributes("OBJECTID"))
      intIndex = intIndex + 1
    Next

    Dim rp As New RelationshipParameter
    rp.ObjectIds = listObjIds
    rp.RelationshipId = 0
    rp.ReturnGeometry = False
    rp.OutFields = {"*"}

    qtRelatedTables.ExecuteRelationshipQueryAsync(rp)

  End Sub
  Private Sub qtRelatedTables_ExecuteRelationshipQueryCompleted(ByVal sender As Object, ByVal e As RelationshipEventArgs)
    If e.Result Is Nothing Then
      Return
    Else
      MessageBox.Show("Bingo")
    End If
  End Sub
  Private Sub qtRelatedTables_Failed(ByVal sender As Object, ByVal args As TaskFailedEventArgs)
    MessageBox.Show("Query failed: " & args.Error.Message)
  End Sub

  Private Sub Query_Failed(ByVal sender As Object, ByVal args As TaskFailedEventArgs)
    MessageBox.Show("Query failed: " & args.Error.Message)
  End Sub

Re: Please help with ExecuteRelationshipQueryAsync

JenniferNery — Wed, 24 Nov 2010 16:49:56 GMT

Your code looks good. I think you are in the right track now. It works, right?

Re: Please help with ExecuteRelationshipQueryAsync

DeraldDudley — Sun, 12 Dec 2021 04:06:42 GMT

Jenn,

I got yours to work using the code below. It is retrieves the Realted records per individual feature. I was confused because I thought the RelationshipParameter.ObjectIDs was looking for a list of IDs. I was trying to set RelationshipParameter.ObjectIDs = FeatureSet.ObjectIDs but I think there is a conversion issue.

Many Thanks,
Derald

If queryArgs.FeatureSet Is Nothing Then
      Return
    End If

    Dim FeatLayr As ESRI.ArcGIS.Client.FeatureLayer = Map1.Layers("Institutions")
    Dim resultFeatureSet As FeatureSet = queryArgs.FeatureSet
    Dim graphicsLayer As ESRI.ArcGIS.Client.GraphicsLayer = TryCast(Map1.Layers("Institutions"), ESRI.ArcGIS.Client.GraphicsLayer)

For Each graphicFeature As ESRI.ArcGIS.Client.Graphic In resultFeatureSet.Features
  graphicsLayer.Graphics.Add(graphicFeature)
  RelatedQuery(Convert.ToInt32(graphicFeature.Attributes(FeatLayr.LayerInfo.ObjectIdField)))
Next graphicFeature

Private Sub RelatedQuery(ByVal ObjectId As Int32)

Dim qtRelatedTables As New QueryTask("http://204.68.195.113/ArcGIS/rest/services/DOTResearch/DOTResearchGDB/MapServer/4")

AddHandler qtRelatedTables.Failed, AddressOf qtRelatedTables_Failed
AddHandler qtRelatedTables.ExecuteRelationshipQueryCompleted, AddressOf qtRelatedTables_ExecuteRelationshipQueryCompleted

    Dim rp As New RelationshipParameter
    rp.ObjectIds = {ObjectId}
    'rp.ObjectIds = resultsFS.ObjectIDs
    rp.RelationshipId = 0
    rp.ReturnGeometry = False
    rp.OutFields = {"*"}

    qtRelatedTables.ExecuteRelationshipQueryAsync(rp)

  End Sub

Re: Please help with ExecuteRelationshipQueryAsync

DaveTimmins — Wed, 24 Nov 2010 18:32:47 GMT

Hi Jennifer,

I think there's a bug / feature 🙂 in the way that the object id field name is used. If you look at the service metadata for

http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/MapServer/0

or

http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/0

you can see that the objectid field reported for the service is objectid.
If you look at the fields data for the service, the objectid field also has an alias set to Object ID and this is the value that is in the Attributes so it can't find the values correctly. So basically it isn't using the alias when it looks like it should be.

Cheers,

Re: Please help with ExecuteRelationshipQueryAsync

JenniferNery — Sun, 12 Dec 2021 04:06:45 GMT

I tried the following code to check that the ObjectIdField in LayerInfo is the same key used to retrieve the graphic ID. It worked on both Map Service and Feature Service you provided, even if they had an alias, they still use field name as key, not the alias.

  public MainPage()
  {
   InitializeComponent();
   FeatureLayer l = new FeatureLayer() { Url = "http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/MapServer/0" };
   l.OutFields.Add("*");
   l.Initialized += l_Initialized;  
   l.Initialize();
  }

  void l_UpdateCompleted(object sender, EventArgs e)
  {
   FeatureLayer l = sender as FeatureLayer;
   l.UpdateCompleted -= l_UpdateCompleted;
   var id = l.LayerInfo.ObjectIdField;
   int objId;
   foreach (var g in l.Graphics)
    objId = Convert.ToInt32(g.Attributes[id]);
  }

  void l_Initialized(object sender, System.EventArgs e)
  {
   FeatureLayer l = sender as FeatureLayer;
   l.Initialized -= l_Initialized;
   l.UpdateCompleted += l_UpdateCompleted;
   l.Update();
  }

If you need to get the alias of a given field, LayerInfo has Fields property, each field will have these information:
http://help.arcgis.com/en/webapi/silverlight/apiref/ESRI.ArcGIS.Client~ESRI.ArcGIS.Client.Field_members.html

string alias;
foreach(var f in l.LayerInfo.Fields)
 alias = f.Alias;

Dave,

Can you try the code above and see if the "bug/feature :)" exist? I can use ObjectIdField to get the object ID from Attributes. Please let me know how I can reproduce it.

Thanks.

Re: Please help with ExecuteRelationshipQueryAsync

JenniferNery — Wed, 24 Nov 2010 19:21:07 GMT

Jenn,

I got yours to work using the code below. It is retrieves the Realted records per individual feature. I was confused because I thought the RelationshipParameter.ObjectIDs was looking for a list of IDs. I was trying to set RelationshipParameter.ObjectIDs = FeatureSet.ObjectIDs but I think there is a conversion issue.

Many Thanks,
Derald

I think your code looks fine already, you did not have to rewrite it to conform to the code I posted earlier. I simply suggested using LayerInfo.ObjectIdField so you don't have to hardcode the key. You are right that the RelationshipParameter takes an enumerable of ObjectIDs. The code snippet I posted was intended for checking against one ID only and therefore not suitable solution for your application if you need to check against multiple ID's - you would have to tweak it a little bit. And I do not see anything wrong in the code you posted (#7)http://help.arcgis.com/en/webapi/silverlight/apiref/ESRI.ArcGIS.Client~ESRI.ArcGIS.Client.Tasks.RelationshipParameter~ObjectIds.html

Re: Please help with ExecuteRelationshipQueryAsync

DaveTimmins — Sun, 12 Dec 2021 04:06:47 GMT

Hi Jennifer,

I was doing executing an IdentifyTask which is why the results have the alias set rather than the underlying field name.

If I use

string objectIdFieldAlias = featureLayer.LayerInfo.Fields.Single(field => string.Equals(field.Name, featureLayer.LayerInfo.ObjectIdField)).Alias;

foreach (var relationship in featureLayer.LayerInfo.Relationships)
                {
var objectIds = e.IdentifyResults.Select(item => Convert.ToInt32(item.Feature.Attributes[objectIdFieldAlias])).ToList();

then it works fine.

Also another query. How can you tie the related records back to the original result? I have the following code to handle the results from ExecuteRelationshipQueryAsync

void ExecuteRelationshipQueryCompleted(object sender, RelationshipEventArgs e)
        {
            if (!e.Result.RelatedRecordsGroup.Any()) return;

            var existingResults = e.UserState as IEnumerable<IdentifyResult>;
            if (existingResults == null) return;
           // RelationshipResult pr = e.Result;

            foreach (var graphic in
                e.Result.RelatedRecordsGroup.Values.SelectMany(graphics => graphics))
            {
               // TODO : get the existing result
               var existingResult = ??????

                foreach(var attribute in graphic1.Attributes)
                {
                    string key = attribute.Key;
                    existingResult.Feature.Attributes.Add(string.Format("{0} (related)", e.Result.Fields.Single(field => string.Equals(field.Name, key)).Alias), attribute.Value);
                }
            } 
        }

The objectid for the original feature matches the value for sf_311_serviceoid in the related result but how do I know that I need to match it against that field?

Cheers,

Re: Please help with ExecuteRelationshipQueryAsync

JenniferNery — Sun, 12 Dec 2021 04:06:50 GMT

Oh I see. You are talking about this thread http://forums.arcgis.com/threads/16331-Results-from-IdentifyTask-are-not-correct-(indexed-by-Field-Alias) where IdentifyResults use Alias. This bug has been reported to ArcGIS Server Team.

As for your other question, you can use the UserToken parameter of the ExecuteRelationshipQueryAsync to hold the existing graphics.

For example:

// more code here
  qt.ExecuteRelationshipQueryAsync(rp, incidentsLayer.Graphics);
}
private void qt_ExecuteRelationshipQueryCompleted(object sender, RelationshipEventArgs e)
{
 GraphicCollection graphics = e.UserState as GraphicCollection;
// more code here
}

Also, when performing a Query to the Related Table, you don't need to know which field in the table is being matched against the layer's Object ID's. These are the only parameters your application need to know: http://sampleserver3.arcgisonline.com/ArcGIS/SDK/REST/index.html?fsqueryrelated.html

Re: Please help with ExecuteRelationshipQueryAsync

DaveTimmins — Wed, 24 Nov 2010 23:45:54 GMT

Hi Jennifer,

OK so the e.Result.RelatedRecordsGroup.Keys are the original feature ObjectID values. Not that clear from the documentation.

Cheers,

Re: Please help with ExecuteRelationshipQueryAsync

YingLin — Fri, 07 Jan 2011 15:38:16 GMT

I have got the relationship query working. however, having trouble to display the result. from the relationshhip query result, i can get the fileds but where are the values for the fields? I'd like to bind the info from the related table to a datagrid.

the following code return null.
GraphicCollection graphics = e.UserState as GraphicCollection;

Re: Please help with ExecuteRelationshipQueryAsync

YingLin — Fri, 07 Jan 2011 16:57:26 GMT

Never mind. the objectID wasn't passed properly. it is working now.

Re: Please help with ExecuteRelationshipQueryAsync

BrandonCales — Tue, 08 Mar 2011 20:35:27 GMT

I've tried the above to Query Related Records and just can seem to get it to work. Maybe I'm missing some code or am just not placing it in the right location. I know I have other code in there already and fitting things in seems to always be the problem, however here is my code - if anyone has input, I'd greatly appreciate it.

.xaml - This shows the DataGrid2 that I want to populate with related records

.cs - this shows the code behind. I was trying to place this inline with my ParcelSearch_TaskResultsDataGrid_SelectionChanged. No matter how I add it in, it just doesn't seem to flow or acccept it.

Re: Please help with ExecuteRelationshipQueryAsync

BrandonCales — Sun, 12 Dec 2021 04:06:53 GMT

Got it working, just needs some final cleanup....not sure if its the optimal way, but it works nice.

private void ParcelSearch_TaskResultsDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {

            foreach (Graphic g in e.AddedItems)
            {
                g.Select();

                if (g.Attributes["OBJECTID"] != null)
                {
                    var id = g.Attributes["OBJECTID"];
                    PARCELIDPASS.Text = string.Format("The ParcelID passed is {0}", id);

                    ParcelSearch_RelatedRecords(null, null, Convert.ToInt32(g.Attributes["OBJECTID"]));
                }
                break;
            }

            foreach (Graphic g in e.RemovedItems)
                g.UnSelect();
        }

        private void ParcelSearch_RelatedRecords(object sender, RoutedEventArgs e, Int32 objectid)
        {
            // QueryTask initialization
            QueryTask ParcelSearch_Related = new QueryTask("{SERVER}/MapServer/79"); //82
            ParcelSearch_Related.ExecuteRelationshipQueryCompleted += ParcelSearch_Related_ExecuteRelationshipQueryCompleted;
            ParcelSearch_Related.Failed += ParcelSearch_Related_Failed;

           //Relationship query
            RelationshipParameter relationshipParameters = new RelationshipParameter()
            {
                ObjectIds = new int[] { objectid },
                OutFields = new string[] { "*" },
                RelationshipId = 1,
                OutSpatialReference = MyMap.SpatialReference
            };

           ParcelSearch_Related.ExecuteRelationshipQueryAsync(relationshipParameters);
        }

        private void ParcelSearch_Related_Failed(object sender, TaskFailedEventArgs args)
        {
            MessageBox.Show("ParcelSearch_Related Failed: " + args.Error);
        }

        void ParcelSearch_Related_ExecuteRelationshipQueryCompleted(object sender, RelationshipEventArgs e)
        {
            RelationshipResult pr = e.Result;
            if (pr.RelatedRecordsGroup.Count == 0)
            {
                ParcelSearch_TaskResultsDataGrid2.ItemsSource = null;
            }
            else
            {
                foreach (var pair in pr.RelatedRecordsGroup)
                {
                    ParcelSearch_TaskResultsDataGrid2.ItemsSource = pair.Value;
                }
            }
        }

Re: Please help with ExecuteRelationshipQueryAsync

BrandonCales — Wed, 09 Mar 2011 22:10:30 GMT

Now I am trying to get this to populate RowDetails rather than a DataGrid in another Panel....if anyone has any ideas.

http://asimsajjad.blogspot.com/2010/04/rowdetailtemplate-of-datagrid-control.html