topic Re: Using Related Tables in Flex Viewer in ArcGIS Viewer for Flex Questions

Using Related Tables in Flex Viewer

AmySadler — Thu, 31 May 2012 19:09:14 GMT

Hello! I am fairly new to using ArcGIS for Flex and am trying to set up a viewer for my organization. I am wanting to use the Query widget to allow users to search for information on a table. The table is related back to a layer and I can see it on my server, but when I go to use the data in the widget, I get error #1009. Is it possible to use a table in the query widget or does it have to be a feature class?

On a related note, can you use information in a related table to populate a "pop-up" for a feature?

Thanks very much for your help!
Amy S.

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Sat, 02 Jun 2012 14:01:17 GMT

Amy,

Relates can be accessed using my eSearch but as relates require you to specify which relate you are wanting data returned for you can not use them in popups. The query widget is for display of geometry and not just querying tabular data.

Re: Using Related Tables in Flex Viewer

AmySadler — Tue, 10 Jul 2012 17:21:40 GMT

Thanks for the info! How do you use eSearch? So does this mean there isn't a way to display related tables in Flex?

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Tue, 10 Jul 2012 18:28:07 GMT

Amy,

"How do you use eSearch?" It is just like the search widget that come with the viewer but with MANY more options and capabilities. Many times it is easier to dig in than try to think about things to much.

"So does this mean there isn't a way to display related tables in Flex?" No, there are ways to display related tables in FLEX, but I assume you are not a developer. There is not a widget already created for displaying related tables besides my eSearch, that I am aware of.

Re: Using Related Tables in Flex Viewer

AmySadler — Tue, 10 Jul 2012 19:21:41 GMT

I am most definitely not a developer. Thanks for the information! I will try this and let you know how it works!

Re: Using Related Tables in Flex Viewer

AmySadler — Thu, 02 Aug 2012 20:54:19 GMT

Robert,

I have added your widget to my Flex Viewer and it is fantastic! Thanks for your work on this!

I do have one question though. I am trying to display related records (which are in a table) of a spatial layer, but so far, I haven't been able to get the related records to show. Is this possible or am I just doing something wrong?

Thanks again!

Amy

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Thu, 02 Aug 2012 21:55:33 GMT

Amy,

If you can see the relate when you go to the rest service directory then it will work with my widget.

Re: Using Related Tables in Flex Viewer

scottBassingthwaite — Fri, 03 Aug 2012 13:39:39 GMT

Robert,

I have a join in mxd (9.3.1) and am trying to query layer with eSearch widget (2.5). I can see all the fields in the rest but darned if I can return anything (getting 400 error). Not sure of the query syntax in the eSearch.xml, expression.

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Fri, 03 Aug 2012 13:48:22 GMT

Scott,

If you are using a join then you will have to use the full field names like this:

Calhoun_Soils.MUSYM = '[value]'

Re: Using Related Tables in Flex Viewer

JosephAccardi — Sat, 04 Aug 2012 11:10:23 GMT

"So does this mean there isn't a way to display related tables in Flex?" No, there are ways to display related tables in FLEX, but I assume you are not a developer. There is not a widget already created for displaying related tables besides my eSearch, that I am aware of.

Robert, I'm using your eSearch widget to export out graphical searches to .csv format (http://forums.arcgis.com/threads/63074-Select-and-Export-features.-eSearch). As discussed in this thread, your eSearch widget allows a user to view related tables, similarly to your InfoTemplate widget, but does the eSearch widget allow a user export out a graphical search result with related tables appended to the selected records in the data grid?

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Sat, 04 Aug 2012 20:58:33 GMT

Joseph,

I don't think that is even possible in ArcMap... No this is not a capability of the eSearch and is unlike to be added based on the complexity of the task. Think about what would have to happen if there was a one to many relate of one record with thousands of related records to just that one result....

Re: Using Related Tables in Flex Viewer

JosephAccardi — Tue, 07 Aug 2012 11:23:52 GMT

No problem Robert. The way you do it in ArcMap is if your feature class and related table are saved in a geodatabase you can perform a 1:M join. A join within a geodatabase will populate all matching records (not just the first matching record). From there you can export out the feature class to append the related attributes. (http://resources.arcgis.com/en/help/main/10.1/index.html#//005s0000002n000000).

Thanks,
Joe

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Tue, 07 Aug 2012 11:41:55 GMT

Joe,

OK, that make sense. Joins and Relates are two different animals.

Re: Using Related Tables in Flex Viewer

MichaelVolz — Wed, 05 Sep 2012 11:40:05 GMT

Robert:

Can you use a mapservice with a datasource that uses a Query Layer to a SQL Server database table with your eSearch widget? I would like to be able to access related records that have been enabled from the Query Layer?

If this is possible, what version of your widget and/or the FlexViewer software would be needed?

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Wed, 05 Sep 2012 12:15:36 GMT

Michael,

I can not say that I have tested Query Layers in the eSearch widget. Give it a go and let me know the results.

Re: Using Related Tables in Flex Viewer

MichaelVolz — Wed, 05 Sep 2012 18:28:52 GMT

Robert:

I first tried to make configuration changes that would allow me to with related record information in the datagrid for a Query Layer, but that did not return any records.

I then made configuration changes just to use a standard ArcMap relate and that also did not return any records.

Does the related records mean you can access records from a relate created in ArcMap? Or does it mean something else?

Can you explain how the configuration file should be modified so the related records get populated?

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Wed, 05 Sep 2012 18:33:08 GMT

Michael,

The relate has to be accessible for the REST Service directory. So when you publish a mxd that has a relate in ArcMap or a real relationship class in a geodatabase that relate gets exposed in the REST Service directory. There are examples of relates in the eSearchWidget.xml that come with the eSearch download.

Re: Using Related Tables in Flex Viewer

MichaelVolz — Wed, 05 Sep 2012 18:46:53 GMT

How would I be able to tell from the REST page that the relate is accessible from ArcGIS Server?

Can you pinpoint where in the documentation I would find more information about accessing related records?

Re: Using Related Tables in Flex Viewer

RobertScheitlin__GISP — Wed, 05 Sep 2012 19:08:15 GMT

Michael,

   You can see if a relate is available when you go to the REST Service directory for your map service layer and scroll down to the bottom. It would look something like this:

Relationships:

    calhoun.COUNTY.A_Bridge (0) -- Related To: ABIMS Bridges (0)
    calhoun.COUNTY.ADT (1) -- Related To: Average Daily Traffic (1)
    calhoun.COUNTY.Rail_Cross (2) -- Related To: Railroad Crossings (2)
    calhoun.COUNTY.Signs (3) -- Related To: Road Signs (3)
    calhoun.COUNTY.Guardrail (4) -- Related To: Guardrails (4)

Supported Interfaces:   REST

Supported Operations:   Query   Query Related Records

As far as documentation for using relates in my widget that would be covered in the Enhanced Search Widget XML Configuration.pdf page 5.

Re: Using Related Tables in Flex Viewer

MichaelVolz — Thu, 06 Sep 2012 11:54:13 GMT

Robert:

Thank you for the additional information, but the related records portion of the datagrid is still not getting populated.

When I first accessed the REST services the relationship did not show up even though a relationship existed on the layer. The layer was created from a lyr file and when the lyr file is brought into an mxd, the related tables do not automatically appear. I needed to open the table view and then use the Related Tables button on the toolbar to bring in the related tables. I then had to stop and start the mapservice and refresh the REST cache.

Do I need to add table information for the related table in the config file below the layers definition area? I did not add table information below the layers area as I thought the fields all="true" would populate the related record portion of the datagrid.