topic Re: Get related objects in Arcade in Developers Questions

Get related objects in Arcade

TheodoreRakel — Mon, 19 Jun 2017 22:06:12 GMT

Is there a way in the Arcade Labeling profile to access the objects related to a feature?

Re: Get related objects in Arcade

JeffreyOwen1 — Tue, 20 Jun 2017 16:58:25 GMT

I came here to ask this exact question. Let me know if you figure anything out. I want to label or symbolize based on the number of related features. I found you can access related feature information in the pop-up configuration (ArcGIS Online), but not the labeling expression (or at least what I could figure out.)

Re: Get related objects in Arcade

TheodoreRakel — Wed, 21 Jun 2017 14:43:16 GMT

Can you share how you were able to access related feature information in the pop-up configuration in ArcGIS Online? I don't see how to do that. Thanks.

Re: Get related objects in Arcade

JeffreyOwen1 — Wed, 21 Jun 2017 16:32:32 GMT

This might not be what you are looking for but it worked somewhat for me since I only want the count of related features.

Go into the Configure pop-up menu. There you will have the option all the way at the bottom to "Show related data" which will put a hyperlink in the popup that will open the attribute table of the related features. But also you can click the "Configure Attributes" link.

Then you should see the related table attributes but it only appears to allow you to display a count (which again is what I needed).

Re: Get related objects in Arcade

JeffreyOwen1 — Wed, 21 Jun 2017 16:35:12 GMT

And also I forgot to mention that I also see related layer/table info available in the Chart configuration at the bottom of that first screenshot.

Re: Get related objects in Arcade

LindsyHales_Bentley — Tue, 29 Jan 2019 15:31:58 GMT

I came here with the same question - is there any update on how to do this?

Re: Get related objects in Arcade

XanderBakker — Tue, 29 Jan 2019 15:50:40 GMT

Yes there is an update. In the december update of ArcGIS Online, an couple of new functions were introduced (FeatureSetBy*) which allow accessing related content (being present in the map or in the same datastore). A couple of resources that you might be interested in are:

The downside is that these functions are not available in the label expression nor in defining the symbology. However, you could create a new field and do the field calculation to access the related content and define the text for the label and label the layer based on that new field. This is not a good option if your data is very dynamic and changes a lot (since it would require you to recalculate the field).

Re: Get related objects in Arcade

LindsyHales_Bentley — Tue, 29 Jan 2019 17:00:59 GMT

Thanks Xander. That is some great stuff.

What if I only want to show a pipeline and it's related table in the popup?

Re: Get related objects in Arcade

XanderBakker — Tue, 29 Jan 2019 18:53:30 GMT

If the related table is published using a relationshipclass, this will be standard functionality that does not requiere any Arcade expression.

The FeatureSetBy* functions in Arcade allow you to create these relations using filters connecting to a table or analyze a spatial relationship between two or more hosted feature layers.

Re: Get related objects in Arcade

LindsyHales_Bentley — Sat, 02 Feb 2019 00:02:41 GMT

I did try publishing out a fc and table using a relationshipclass, however the pop-up still requires you to click "show related records," which opens a table. I am hoping to be able to show all (fc attributes and related record(s)) in a single pop-up (for the not-so-tech-savy).

Re: Get related objects in Arcade

XanderBakker — Sat, 02 Feb 2019 00:32:13 GMT

That is possible. If the idea is to present the user with the attributes of the clicked feature and the related data without the need to click to open the related table, you can do this with the new Arcade functions. If you can explain (show) more about the data schema you have I can help you create an expression.

Re: Get related objects in Arcade

XanderBakker — Sat, 02 Feb 2019 17:57:57 GMT

I have branched your question to a new thread here: https://community.esri.com/message/829126-get-1m-related-objects-using-arcade

Re: Get related objects in Arcade

AndresCastillo — Mon, 25 Mar 2019 14:53:14 GMT

Hi Theodore Rakel, Jeffrey Owen, and Lindsy Hales Bentley

I have come up with a solution to symbolizing from a related table in my post:

Symbolizing Feature Class using related table values

https://community.esri.com/thread/215046-symbolizing-feature-class-using-related-table-values

There is a 17 page word document with details on how to accomplish this.