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

Support for related tables in Operations Dashboard?

StuartRich

Hi,

I am trying to use the Operations Dashboard to display data for features that have information stored in related tables. For example, a building has a table of areas by space type. I have published the related tables through a web map, but the Operations Dashboard does not seem to be able to see them. Does Operations Dashboard have support for related tables?

Thanks in advance,

Stu Rich

タグ付きの投稿をもっと見る

Accepted answers

All comments

RobDunfey

This would be useful

SuneDue_Møller

Did you post the idea on ideas.Arcgis.com ?

- Sune

BenStaud

I agree. This functionality would be very helpful. I would like to see not only a table view but the ability to use related tables within Widgets to display data and run queries.

JeffShaner

All,

This is great feedback. We are looking to add this capability into a future release but we need your help in detailing the need.

Some thoughts on level of support for tables:
1. Add as an external data source where I can browse for an item or directly to the REST endpoint of a non-spatial table. Of course in say a list widget you would not see a legend swatch for each row as there is nothing we can draw.
2. Similar to 1 we could add the ability for you to navigate through the collection of feature services within a web map to each of the tables and set a table as a data source.

The challenge comes with 1:M relationships. If you can provide us with details on your need, that would be extremely helpful. You can either post directly to this forum thread or email dashboard4arcgis@esri.com.

Thanks!

Jeff

DebraVian

Yes, the ability to use related tables in dashboard views is very important. We are highly interested in this functionality. How we would use related tables if we could?

A spatial feature on a map is related to a non-spatial table. User clicks on the related table icon in a list of features or the feature detail or the feature pop-up and they see the table.

1. Table contains date, short description of, and hyperlinks to documents, photos, etc. Many documents/photos are related to this one feature. User selects a record in the table and the document/photo opens on their computer.

2. Table contains monitoring data over the past 10 years. Several elements are monitored for each spatial feature. User clicks on one of the monitored elements in the table and is prompted to enter a time range. A graph of monitoring results for the element over selected time frame pops-up. User can export the graph as a jpg.

GregYetman

The July update added support for showing related records in a pop-up (link below), showing summary statistics for one-to-many relationships and the related records for one-to-one relationships. I just tested with both a feature service and a map service from ArcGIS for Server 10.2 and it appears that while my related records show in the pop-up inside the ArcGIS online Viewer, they do not display in the pop-up inside the Operations Dashboard. All of the related records are listed as null, even if there are related records.

Has anyone else tested this? If there is a way to show the related records in the Dashboard it would be useful.

Configure pop-ups—Help | ArcGIS‌

JeffShaner

The Apps team is working to add related table support inside of the Collector, Operations Dashboard and Explorer apps. Where appropriate we will include editing support as well (which is not yet available). Look for these capabilities to be added to the rest of the platform through the course of our 10.3 release. Also we will blog and announce when these capabilities are added.

RachelS

Is there any update to supporting related tables in Operation dashboard?

I want to be able to create a bar chart of total (text) features in the related 1-M table.

Also, I'd like users to be able to view the feature of the related table somehow.

Is it going to happen anytime soon?

DebraVian

Rachel, ESRI is saying that they will roll this out in 10.3 at the and of thIs year. Yes, we are waiting.

Debra

RachelS

Great, 10.3 is due to be released this month. hopefully not much longer to wait.

JeffShaner

All - we will have an update to the Operations Dashboard coming in December but....

It will not include support for related tables as a data source. What we will provide is the ability for you to browse for a standalone table as an external data source and you can apply a filter to that data source if you like. However we will NOT yet support the ability to navigate an established geodatabase relationship class.

Unfortunately that fell out of scope for our release. It is still high on our list and includes support for related tables in the popup as well as the data source.

Note that we are augmenting the related tables definition in the webmap to support the release of Collector with related table editing (10.3). You will be able to define a popup on a table with this update. We want to take advantage of this feature being added when supporting related tables in the Operations Dashboard as well.

Jeff

TedChapin

Jeff,

Looks like still no support for related tables in Operations Dashboard. I like the idea of using the standalone table as a workaround, however, I haven't been able to link a query on the standalone table to a selected record in another layer. Ideally I would like to query a feature layer, display the results in a list, and when I click on one of the results, show a list of the results of another query against the standalone table. I can't figure out how to do this. Can you make a query where the value is equal to the field of a selected record in another list widget? Then you could do this without needing a native relationship.

Ted

AndrewHargreaves

Hey everyone,

I just stumbled across this thread as I ran into the exact same issue - the need to access related tables within Operations dashboard. Here's how I solved it:

I have a hosted feature service with a related table in my map. I can't access this related table as a data source in my map, or even as external data source.

But, as @Jeff Shaner explains above there is support for a stand alone table. What i did was take the Service URL of that (hosted) related table, add it as a new item in my ArcGIS Online content, and access that as an external data source. Now, when field crews make a new inspection record in the field using Collector the results show up in my dashboard.

Thanks

ChristopherOlsen

Here's link to the video I made showing how you can use related tables in Operations Dashboard. Hope this helps with some of the issues that have come up in supporting related tables.

Andrewwilhelm1

^this is exactly what I'm looking for as well

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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