topic Re: Support for related tables in Operations Dashboard? in ArcGIS Dashboards Questions

Support for related tables in Operations Dashboard?

StuartRich — Tue, 02 Jul 2013 09:16:17 GMT

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

Re: Support for related tables in Operations Dashboard?

RobDunfey — Tue, 12 Nov 2013 19:03:09 GMT

This would be useful

Re: Support for related tables in Operations Dashboard?

SuneDue_Møller — Tue, 07 Jan 2014 07:18:48 GMT

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

- Sune

Re: Support for related tables in Operations Dashboard?

BenStaud — Tue, 07 Jan 2014 12:28:32 GMT

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.

Re: Support for related tables in Operations Dashboard?

JeffShaner — Tue, 06 May 2014 13:10:19 GMT

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

Re: Support for related tables in Operations Dashboard?

DebraVian — Wed, 07 May 2014 18:28:14 GMT

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.

Re: Support for related tables in Operations Dashboard?

GregYetman — Mon, 21 Jul 2014 18:09:49 GMT

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‌

Re: Support for related tables in Operations Dashboard?

JeffShaner — Wed, 23 Jul 2014 06:03:36 GMT

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.

Re: Support for related tables in Operations Dashboard?

RachelS — Mon, 10 Nov 2014 13:46:09 GMT

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?

Re: Support for related tables in Operations Dashboard?

DebraVian — Mon, 10 Nov 2014 14:57:19 GMT

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

Debra

Re: Support for related tables in Operations Dashboard?

RachelS — Mon, 10 Nov 2014 15:04:12 GMT

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

Re: Support for related tables in Operations Dashboard?

JeffShaner — Tue, 25 Nov 2014 23:40:57 GMT

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

Re: Support for related tables in Operations Dashboard?

TedChapin — Mon, 16 Mar 2015 19:39:04 GMT

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

Re: Support for related tables in Operations Dashboard?

AndrewHargreaves — Mon, 27 Jul 2015 18:30:30 GMT

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

Re: Support for related tables in Operations Dashboard?

simoxu — Fri, 25 Sep 2015 13:05:24 GMT

Jeff ShanerAndrew Hargreaves

It's true that the related tables can be added as external datasources.

But there's a problem, for example, you have a list widget using the external datasource, and you have a map widget as well in the OD. the list widget and the map widget are not linked, no feature actions will be working in the list widget! In the real case, this kind of the dashboard could be confusing and misleading.

To make the related table and the map widget work together, as Ted Chapin mentioned in his post, you need to develop a custom widget, in the widget (let's say a list widget built in JavaScript)

1. Use the map widget as the datasource

2. Query the related table directly, Featurelayer.queryFeatures(...), something like that, and make sure to configure your widget so that it can use your dashboard credential to do the query, otherwise it will ask you for credentials.

3. Append the fields from the related table to the map layer features when building the store for the list.

4. After step 3, when building the list, you can determine which fields to display, from the related table or from the layer.

5. Now the list widget and the map is linked. you can use highlight, zoom to , and so on feature actions.

The reason this trick will work is that the featureactionFeatures don't care what you display in the list, as long as you keep the datasourceproxy and IDs of the features, the predefined featureactions will work.

This solution is far from perfect, this twist make me feel I am hacking the system.

Hope ESRI can give us an update for the OD, and let it support related tables, then we can have a more elegant solution.

Cheers,

Simo

Re: Support for related tables in Operations Dashboard?

VickyS — Tue, 06 Oct 2015 10:15:28 GMT

Is there an update on this? We really need it so we can make the most of the data collected using the Collector App. Managers need to be able to see the details of the item and problem is related to.

Thank you

Re: Support for related tables in Operations Dashboard?

ChristopherOlsen — Wed, 20 Apr 2016 20:35:15 GMT

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.

Re: Support for related tables in Operations Dashboard?

Andrewwilhelm1 — Thu, 09 Jun 2016 18:25:02 GMT

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