topic Re: Related tables in 10.1 in ArcGIS Enterprise Questions

Related tables in 10.1

BillZborowski — Fri, 15 Mar 2013 17:32:21 GMT

Hi Guys,

I'm not sure if I'm doing this wrong or what, but I can't get related tables to show up using the ArcGIS Rest API in 10.1. I have a map document with a table of STATE attributes and a table of child attributes (1 state per many child table). I go into the state TABLE in arcmap --> Joins & Relates --> Relate... to create the relationship. In ArcMap, everything is perfectly okay. However, when I publish to 10.1 Server it pretends no relationship actually exists. What gives?

I want to be able to query related records through the REST API like this....but with two non-spatial tables.
http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/Petroleum/KSPetro/MapServer/2

Re: Related tables in 10.1

MichaelVolz — Fri, 15 Mar 2013 18:25:53 GMT

Is the related table in the same database as the feature class you are relating it to? I ask because ArcGIS Server needs access to both locations in order for the mapservice to be published correctly.

Re: Related tables in 10.1

BillZborowski — Fri, 15 Mar 2013 18:31:35 GMT

Is the related table in the same database as the feature class you are relating it to? I ask because ArcGIS Server needs access to both locations in order for the mapservice to be published correctly.

Yes, they are. I exported from SDE to a single FGB, which the server has access to.

Re: Related tables in 10.1

MichaelVolz — Fri, 15 Mar 2013 18:38:13 GMT

When you go to the REST endpoint in a browser and click on the feature class link, you do not see any relationships defined between the feature class and table at the bottom of this page?

Re: Related tables in 10.1

TimothyMichael — Mon, 08 Apr 2013 20:07:34 GMT

My understanding is the ability to query related data requires feature access to be enabled on the map service, which requires that the data be in an enterprise geodatabase (SDE). Have you tested a map service referencing your data in SDE (not the exported FGDB)? Here is an article from the .NET help:

http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//009300000021000000