topic Re: "Nested" Relationships in AGOL in ArcGIS Online Questions

"Nested" Relationships in AGOL

LisaHuggins — Fri, 19 Jun 2015 17:50:59 GMT

I have a feature class, "patchlocation". This FC is related to table "Rack" 1:M. The table "Rack" is then related to a table "Patchpanel" 1:M. In ArcMap, I can identify a "patchlocation" on the map and then look at related racks and from each rack, related patchpanels. I published map to service but when I identify in AGOL, I only get related racks. Is this type of "nested" relationship supported in AGOL?

Re: "Nested" Relationships in AGOL

James_Whitacre — Tue, 23 Jun 2015 18:57:46 GMT

Lisa,

I dealt with this same issue a few years ago because I wanted to create the Macroinvertebrate Water Monitoring Map. My dataset seems similar. I had sites (FC) with multiple visits per site (1:M FC > table) with multiple macros collected at each site visit (1:M table > table).

AGOL only allows you to see one level of relationships. However, you can use the JavaScript API to customize returns of 'deeper' relationships as we did in our map from above. I worked with a developer, as I am still early in my JavaScript programming skills, so I can't offer much more than this!

I have not seen a widget yet to replicate what happens when you use the identify tool in ArcMap where you get to see the whole relationship tree. The ability to add related values to the popup is a good step, but certainly does not meet the complete need in your case.

James

Re: "Nested" Relationships in AGOL

LisaHuggins — Tue, 23 Jun 2015 19:08:16 GMT

Thanks for the response! Always nice to know that someone is listening. And while Im sorry there is not currently an out of the box solution, it's good to know there is a solution out there we can work towards. Thanks again.

Re: "Nested" Relationships in AGOL

RussRoberts — Tue, 23 Jun 2015 19:31:11 GMT

Hey Lisa,

Nested relationships are planned to be supported in ArcGIS Online later this year.

Cheers

Russ

Re: "Nested" Relationships in AGOL

LisaHuggins — Tue, 23 Jun 2015 19:37:12 GMT

Woohoo! That's nice to hear. We'll be waiting. Thanks

Re: "Nested" Relationships in AGOL

Reynaldde_Castro — Wed, 24 Jun 2015 15:09:32 GMT

Very nice site

Re: "Nested" Relationships in AGOL

MichaelRobb — Wed, 11 Nov 2015 01:58:55 GMT

Its later in the year.. still no nested relationships Feature >> 1:M >> Table ---- Table >> 1:M >> Table.

Is there a better timeline as to when this will be released?

Re: "Nested" Relationships in AGOL

MaximeDemers — Tue, 26 Feb 2019 20:28:32 GMT

We are in 2019, does nested relationships in AGOL webb app is enabled or not?

Re: "Nested" Relationships in AGOL

RussRoberts — Tue, 26 Feb 2019 21:09:13 GMT

Yes you could view nested relationships in the Map Viewer. Using the Popup Show Related Records > Using the table view to see the next level of related records. You can also use WAB popup to navigate through nested relationships.

Re: "Nested" Relationships in AGOL

MaximeDemers — Wed, 27 Feb 2019 13:44:33 GMT

Thank you for your answer.

Is it normal that if I add a MapService hosted on an ArcGIS Server into the AGOL webmap viewer (https://www.arcgis.com/home/webmap/viewer.html) I just see the first level of relationships in the table view? Nested relationships are displayed as empty (0).

Re: "Nested" Relationships in AGOL

RussRoberts — Wed, 27 Feb 2019 14:10:23 GMT

I think I see the issue you are seeing. It seems to only happen when you get into the nested relationship scenario. Record to Record is working but going into nested relationships -> Record to Record to Record is showing 0s. Can you log a bug with support that you can track the issue?