topic Re: Sample for querying data from related tables in GeoDataServer in ArcGIS API for Flex Questions

Sample for querying data from related tables in GeoDataServer

sidneykelvin — Mon, 02 Aug 2010 07:47:27 GMT

I've got a non-spatial database with related tables published in the ArcService GeoDataServer. Can anybody please give me samples on how to query on those tables in Actionscript.

Thanks in advance.

Re: Sample for querying data from related tables in GeoDataServer

DasaPaddock — Mon, 02 Aug 2010 18:38:17 GMT

Here's a sample that uses the FeatureLayer.
http://help.arcgis.com/en/webapi/flex/samples/index.html?sample=FeatureLayerQueryRelated
http://help.arcgis.com/en/webapi/flex/apiref/com/esri/ags/layers/FeatureLayer.html#queryRelatedFeatures()

You can also use a QueryTask:
http://help.arcgis.com/en/webapi/flex/apiref/com/esri/ags/tasks/QueryTask.html#executeRelationshipQuery()

Re: Sample for querying data from related tables in GeoDataServer

sidneykelvin — Tue, 03 Aug 2010 00:23:41 GMT

dpaddock,

Thank you so much in your valuable advice. I didn't know that a related table can be viewed in the MapServer. In the Web service I published I couldn't view the related table. Can I do it in ArcGIS Server 9.3.1.3000 with mxd created in ArcMap 9.3.1? If yes, please advise what have I done wrong.

If no, I'm trying to work around and putting the tables in the Geodata Server, so can you advise me on samples to retrieve data in the Geodata Server?

Btw, I'm using Flex 3.0, can I make use of similar script from the sample?

Thanks again

Re: Sample for querying data from related tables in GeoDataServer

DasaPaddock — Tue, 03 Aug 2010 15:45:07 GMT

Querying related records via the ArcGIS REST API requires ArcGIS Server 10:
http://sampleserver3.arcgisonline.com/ArcGIS/SDK/REST/queryrelatedrecords.html

You can call a custom server side script to access your data. It can be implemented in any technology you're comfortable with. Here's a discussion on some of the options available:
http://livedocs.adobe.com/flex/3/html/Part4_data_access_1.html

Re: Sample for querying data from related tables in GeoDataServer

sidneykelvin — Wed, 04 Aug 2010 07:29:00 GMT

dpaddock,

I need to work on the matter on ArcGIS Server 9.3.1.3000 and therefore I found the calling for a custom server side script more likely to solve my problem.

However, when I look into the part "Calling HTTP services in ActionScript", I got no idea in making query using the HTTP service.

Can you give samples in this?

Thanks

Re: Sample for querying data from related tables in GeoDataServer

DasaPaddock — Wed, 04 Aug 2010 15:51:31 GMT

Here's a sample from the old forum:
http://forums.esri.com/Thread.asp?c=158&f=2421&t=297646

Here's some generic samples:
http://blog.flexexamples.com/category/httpservice/