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; } } }

Using Related Tables in Flex Viewer

AmySadler

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.

Find more posts tagged with

Accepted answers

RobertScheitlin__GISP

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.

All comments

RobertScheitlin__GISP

Silvana,

Unless you have 8 relates on that layer, you are using the wrong number of the relate ID. The relate ID is the first number presented in the relates section on the REST Endpoint page.

silvanagiberti

Hello,

I am trying to use the eSearch widget with 2 related tables, but so far I have been able to see the data only of the first one. The difference is that the second table is related to the first table, so that in the <relate> section the ID is:
<relate id="8" ...>, where 8 is the ID of table#1.
I am not sure that this is actually possible with the eSearch widget, and eventually how?

Thanks,
Silvana

MikeVolz

Robert:

Thank you for your assistance and your advice on the forum ettiquette. As such I will start a new thread about relates with the eSearch widget so you can get credit for answering my question.

RobertScheitlin__GISP

Michael,

I am spending a bit of time trying to assist you with this, on a hijacked thread that has already been answered... Better forum etiquette would be to start your own thread.

You need to add the relate info as outlined in the "Enhanced Search Widget XML Configuration.pdf" page 5. There are also examples of relate setup in the eSearchWidget.xml (Scroll down and look for the Road Centerline layer).

MikeVolz

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.

RobertScheitlin__GISP

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.

MikeVolz

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?

RobertScheitlin__GISP

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.

MikeVolz

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?

RobertScheitlin__GISP

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.

MikeVolz

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?

RobertScheitlin__GISP

Joe,

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

JosephAccardi

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

RobertScheitlin__GISP

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

JosephAccardi

"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?

RobertScheitlin__GISP

Scott,

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

Calhoun_Soils.MUSYM = '[value]'

scottBassingthwaite

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.

RobertScheitlin__GISP

Amy,

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

AmySadler

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

AmySadler

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

RobertScheitlin__GISP

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.

AmySadler

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

RobertScheitlin__GISP

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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