nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Relationship ID

DavidKelly1

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

Vind meer berichten getagd met

Accepted answers

All comments

januszkrawczynski

Got it.
Thanks,
Janusz

DominiqueBroux

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.

januszkrawczynski

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

DominiqueBroux

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..

januszkrawczynski

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.

DavidKelly1

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

Relationship1.JPG

Relationship2.JPG

DavidKelly1

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

DavidKelly1

Chris/Jennifer,

Thank you.

David Kelly

JenniferNery

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.

DavidKelly1

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

ChristopherHill

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.

DavidKelly1

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

Mainpage.xaml.cs.txt.zip

JenniferNery

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();

Relationships.png

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.