topic Re: Relationship ID in ArcGIS API for Silverlight Questions

Relationship ID

DavidKelly1 — Wed, 24 Aug 2011 17:51:38 GMT

I am new to Silverlight. I am trying to convert the live sample in the ArcGIS API for Silverlight to run with my data. The sample I am using is the related records sample. I need to have the relationship ID, it says to find it in the sertvice directory. What does that mean? How

Thanks for your help,
David

Re: Relationship ID

JenniferNery — Sun, 12 Dec 2021 01:52:54 GMT

You can use FeatureLayer to determine relationshipId (see code below). If you go to the REST endpoint using your web browser go to the URL, you will find relationships section (see attached image).

 
FeatureLayer l = new FeatureLayer() { Url = "http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/Petroleum/KSPetro/MapServer/0" };
l.Initialized += (s, e) =>
{
 int relationshipId = -1;
 foreach (var relationship in l.LayerInfo.Relationships)
 {
  relationshipId = relationship.RelatedTableId;
  break;
 }
};
l.Initialize();

Re: Relationship ID

DavidKelly1 — Fri, 26 Aug 2011 11:27:29 GMT

Jennifer,

Thank you for your help. I tried the code you sent and still did not get an value for the id. Is it possible that there is something wrong with the map service. The map service was made from a single feature layer in ArcMap 9.3.1 with a relate that works to a table in a file geodatabase. The map service displays correctly. When the user clicks on one of the polygon features the form pops up with the correct fields and the expected value for the polygon that was clicked on. When I click on that value I get an error message about cannot have a null value. Below is the section of code where the error occurs:

//Relationship query
                RelationshipParameter relationshipParameters = new RelationshipParameter()
                {
                    ObjectIds = new int[] { Convert.ToInt32(g.Attributes[v_GIS_OPPTY_DETAIL.Tag as string]) },
                    OutFields = new string[] { "OPPTY_NAME, STAGE_DESC_TEXT, IHS_COUNTRY_NAME, HESS_BASIN_ID, FIRST_NAME_TEXT,LAST_NAME_TEXT " },
                    RelationshipId = 0,
                    OutSpatialReference = MyMap.SpatialReference
                };

                queryTask.ExecuteRelationshipQueryAsync(relationshipParameters);

Any additional help is appreciated.

David Kelly

Re: Relationship ID

ChristopherHill — Fri, 26 Aug 2011 23:45:04 GMT

Is the service you are hosting on a ArcGIS 9.3.x server. QueryRelatedRecords was not introduced until ArcGIS Server 10.0. You basically have to establish a sql relationship using ArcMap then publish the service to ArcGIS Server 10.x. When you browser to the REST endpoint the service will have defined what the relationshipIDs are you can use. you can then use the QueryRelatedRecords in the silverlight API to preform the relationship query.

Re: Relationship ID

DavidKelly1 — Sat, 27 Aug 2011 00:53:48 GMT

I am using ArcGIS 9.3.x server. The company has not upgraded to 10. So I will not be able to do this until I can have access to ArcGIS server 10?

David

Re: Relationship ID

JenniferNery — Sat, 27 Aug 2011 01:50:56 GMT

Chris is correct. ArcGIS Server 10.0 introduced relationship as I quote from SDK reference, which means your server will not have this information http://sampleserver3.arcgisonline.com/ArcGIS/SDK/REST/layer.html

From 10 onward, it also provides information regarding the relationship of this layer / table with other layers / tables in the map service. A property to indicate whether the layer / table has attachments or not was also added at 10.

Re: Relationship ID

DavidKelly1 — Sat, 27 Aug 2011 10:55:44 GMT

Chris/Jennifer,

Thank you.

David Kelly

Re: Relationship ID

DavidKelly1 — Mon, 29 Aug 2011 19:56:43 GMT

Chris/Jennifer,

It turns out the company has Server 10 running on one of its other servers so I was able to get the map service published using Server 10. I still get the same error message. Any idea was is causing it.

Thanks,
David

Re: Relationship ID

DavidKelly1 — Mon, 29 Aug 2011 20:59:51 GMT

Chris/Jennifer,

I included some screenshots. The map service using Server 10 was created from a single layer with a relate to a table. Does something else have to be done before I can use the relate feature service the way it is used in the query relate sample on the website? It looks to me like there is not a relationship ID.

David

Re: Relationship ID

januszkrawczynski — Tue, 02 Apr 2013 22:20:17 GMT

What should I do to set Relationship ID?
When I look through Services Directory rest point at may mapservice I do not see Relationshps: at all.

Re: Relationship ID

DominiqueBroux — Thu, 04 Apr 2013 06:54:05 GMT

What should I do to set Relationship ID?
When I look through Services Directory rest point at may mapservice I do not see Relationshps: at all.

You need to add the tables/feature classes the relationships are based on to your map before publishing it..

Re: Relationship ID

januszkrawczynski — Thu, 11 Apr 2013 16:03:39 GMT

You need to add the tables/feature classes the relationships are based on to your map before publishing it..

Once, the relashionship is set.
How can I test it make sure it works?
How do I find RelationshipID?

Thanks,
Janusz

Re: Relationship ID

DominiqueBroux — Tue, 16 Apr 2013 05:27:16 GMT

Once, the relashionship is set.
How can I test it make sure it works?
How do I find RelationshipID?

Thanks,
Janusz

You can send a request to the feature service end point. You should see the relationships ID defined for the service: example.

Re: Relationship ID

januszkrawczynski — Wed, 17 Apr 2013 18:34:28 GMT

Got it.
Thanks,
Janusz