topic Re: Using Related Tables in Operations Dashboard in ArcGIS Dashboards Questions

Using Related Tables in Operations Dashboard

ChristopherOlsen — Tue, 12 Jan 2016 21:33:14 GMT

A lot of people have questions on how to leverage data from related tables using Operations Dashboard for ArcGIS. These tables can be used as data sources and this video takes you through how to set up a Dashboard using some sample data with related tables.

(view in My Videos)

Re: Using Related Tables in Operations Dashboard

KyleWikstrom — Fri, 26 Feb 2016 18:40:06 GMT

This is great stuff!!

Any ideas why no attribute configuration info appears when I add the widget? This is what it leaves me with.

Re: Using Related Tables in Operations Dashboard

ChristopherOlsen — Fri, 26 Feb 2016 19:04:49 GMT

Can you debug using the HTML debugger?

Re: Using Related Tables in Operations Dashboard

TedChapin — Thu, 21 Apr 2016 13:39:54 GMT

Nice job on the video, well explained. Still, it feels like a "workaround" because the user has to type in the ID for the separate query. We always have to wait for related table support to be a natural out-of-the-box feature.

Re: Using Related Tables in Operations Dashboard

ChristopherOlsen — Thu, 21 Apr 2016 16:51:16 GMT

Yup, I completely agree Ted. It's a workaround but I think so many people think that you can't use the tables at all in Ops Dashboard, and that's a myth. So hopefully they can use the workaround to show the data, until we get the better solution in place.

Re: Using Related Tables in Operations Dashboard

Andrewwilhelm1 — Thu, 09 Jun 2016 18:08:01 GMT

This feels awkward and clunky. the related records no longer seem "related" in the map. it's just an external table that has been brought in with search functionality & widget configurability.

Related records work in ArcGIS online, you'd think they'd transfer to the dashboard.

Any updated on this?

Re: Using Related Tables in Operations Dashboard

ThomasHasselbeck — Tue, 01 Nov 2016 22:41:45 GMT

I connect my feature table and related table using a GUID. The idea of my field workers typing in a GUID to see the history of hydrant inspections makes this a nonstarter. Honestly having them type in anything is going to be a horrible user experience and I won't implement it. I understand this is beta software but not supporting related tables will make Dashboard appear half baked IMO.

Re: Using Related Tables in Operations Dashboard

BeckyColwell-Ongenae — Tue, 10 Jan 2017 15:44:54 GMT

colsen-esristaff, I also appreciate this video, but strongly agree that full support of related records and their attachments needs to be supported in Dashboard. When can we expect to see this? I see online posts stemming back to 2013 to support this functionality. ESRI reps responded to those posts, and promises were made to the user community of related record support in upcoming releases, so we know this request made it's way back to the developers.

Dashboard is supposed to be complimentary software to http://learn.arcgis.com/en/projects/manage-a-mobile-workforce/Collector, no? At the point that the demo on how to Manage a Mobile Workforce | Learn ArcGIS was released in 2015, a similar solution should have been in the works for the next release of Dashboard. Not trying to be harsh, but the clock has been ticking for a long time. This support needs to happen in order for us to truly leverage the resources available in Dashboard. I agree with @Thomas Hasselbeck, we won't be deploying Dashboard with "work arounds" that aren't complete, user-friendly solutions.

Please respond with ESRI's timeline for related record, attachments included, widget functionality in Dashboard.

Re: Using Related Tables in Operations Dashboard

MiraEl-Koussa — Fri, 24 Feb 2017 07:58:13 GMT

I have the same question. The data are not related anymore. did you find any solution or trick for this ?

Re: Using Related Tables in Operations Dashboard

TifPun — Fri, 09 Mar 2018 18:53:26 GMT

Hi all,

Using the second-generation Operations Dashboard, we can now configure the visual elements in a dashboard to show and interact with related records.

To illustrate how it works, we prepared this dashboard which contains a hydrant layer and its inspection records. When a hydrant on the list at the top is selected, the list at the bottom will be updated to show the last 10 inspections of that hydrant. You can also click on an inspection record to see its detail.

The relationship/wiring between these visual elements was setup in the Actions menu of the “source” element (the hydrant list in this case). The screenshot below shows how the hydrant list was configured to update the inspection list: First, a “Filter” action was setup on the hydrant list, so that when a list item is selected, the list will use the “common field” (Facility ID) to wire up itself with the “target” element (Inspections List).

If you want to see how the configuration was made, you can make a copy of the dashboard by clicking on the following URL: http://www.arcgis.com/apps/opsdashboard/index.html#/new?id=5294afb250b942698f71cdebafb531dc, it will save a copy of the dashboard into your org under your account. You can then open the Actions menu of the Hydrant List to see the configuration.

If you have specific requirements that our current action framework cannot satisfy, or if you have ideas on how we can make the action framework better, please let us know your thoughts.

Thanks!

Tif

Re: Using Related Tables in Operations Dashboard

Christopher_L_Rogers — Sat, 14 Apr 2018 23:48:27 GMT

Wondering if anyone on the Operations Dashboard Team can help with this conundrum... Jeff Shaner Operations Dashboard for ArcGIS Ismael Chivite

Hi Tif,

This is very nice and extremely useful but I need to take it one step further so I'm hoping you can help me solve this conundrum. I have a Hosted Feature Service layer that was created by a Survey123 I built which also has one related table that contains information as well as pictures that are uploaded. I have successfully created two lists just as you've described here with the first providing the top level information from the Host Feature Service layer, actions are then set to load the second list based on a single selection from the first using the Parent/Child ID Relationship and this works perfect! Now here's the catch when the second list loads from the related table it has references to the photos that were taken and uploaded from the field by the field technician now what I need to be able to do is show the photos in a way that they're either thumbnails in their own View List window perhaps, as icons for each record perhaps (though each record usually has more than one photo), or even as the Pop-Up in a Normal Map handles them by opening up a blank Browser Tab/Window and allowing the viewer to see the pictures all at once or one at a time.

I have looked at the photos in the related table but they don't really exist there as they are merely a reference point that is used in a dynamically built URL/Web call (at least in the case of a normal pop-up in a Map) thus Operations Dashboard doesn't have a smooth intuitive way to handle this. Now I will admit I haven't tried to solve this with the new "Embedded Content" capability yet but I am working on that as we speak so if you have any ideas on how to accomplish this that would be great or at least give me some technical info that might help me understand how to generate the right URL Link to these photos while dynamically passing in the photo reference key I think I can pull a rabbit out of the proverbial hat.

So to clarify the use case and workflow here goes;

I have created a Survey123 that allows Police Officers to work interdictions stop where they will be taking photos of vehicles, vehicle identification plates, license plates, area photos, and other such things and will be uploading the details and photos thought this Survey. The survey has multiple pages one of which has a Repeat in it for the photos and has two data storage parts 1) the Hosted Feature Service layer which contains the main/general information and 2) information one each photo taken and the photo itself uploaded and I can access all of this in Operations Dashboard.

My Workflow...

1) Create the Sruvey123 and upload it whereby instantiating the necessary Hosted Feature Service layer, the Related Table, and a Map connecting it all.

2) Creat a new Operations Dashboard loading the Map from this Survey into it and then adding two lists.

3) Configured, the first list pulls in the data from the Host Feature Service layer and when a record from it is selected it feeds a second list which then pulls the data for each related record to its parent. When I try to then select a related record from the second table I don't see a way to construct a method to see the photos associated with each record. I can however; add an Indicator that provides a count of the number of photos in each related table record so I know I can see the individual photos as records yet I can't seem to figure out how to then create a dynamic link using each photos unique id that a user can click (like in the pop-up of the map) to view them or better yet perhaps using the Embedded Content widget to load the photos in it creating a way to display them all as thumbnails perhaps and if one is clicked see a larger view.

This is a great way for to create a an application that allows Commanders to see what's going on out in the field and then to gain deeper insight into the details of the data submitted through the Survey.

I hope this makes sense and hope you have some ideas as how to make this happen. If I come up with a solution with the new Embedded Content widget I'll let you know and share with the world.

Thanks Tif look forward to seeing you at UC again this year!

Regards,

Chris Rogers

OKDPS

Re: Using Related Tables in Operations Dashboard

MalcolmMeyer2 — Thu, 27 Dec 2018 15:48:08 GMT

Suggested additions to the actions -

Ability to zoom the map, or fit the map bounds, to the filtered feature or features
Add a loading icon or something to the map to let the user know that something is happening in the map as the filter process can be slow depending on the target features

Re: Using Related Tables in Operations Dashboard

JenniferCasey1 — Wed, 16 Jan 2019 22:50:34 GMT

Tif Pun, the URL doesn't seem to work anymore. Is there an updated link?

Re: Using Related Tables in Operations Dashboard

JordanMiller4 — Mon, 10 Jun 2019 19:15:18 GMT

Try using incognito mode.