topic Re: How to use the FeatureSetByRelationshipName Arcade function? in ArcGIS Online Questions

How to use the FeatureSetByRelationshipName Arcade function?

DaveK — Thu, 20 Feb 2020 18:45:28 GMT

Hello,

I am trying to display related table information in my popups within my webmap. I have a layer and its associated related table within my layer list. I set up the Arcade function (FeatureSetByRelationshipName) within the custom attribute expression following the documentation online. When testing the function it seems to work as it should but when I click the popup within the map I get no information. How can I display my feature layer and related table information within the popup?

Thanks!

Re: How to use the FeatureSetByRelationshipName Arcade function?

XanderBakker — Thu, 20 Feb 2020 18:56:52 GMT

Hi David Krady ,

The test result shows that you are receiving a featureset. A featureset however, cannot be visualized in a pop-up, that is why you won't see the information. You need to extract the relevant information from the featureset and return that as a (multiline) string or value.

What do you want to show in the pop-up?

Re: How to use the FeatureSetByRelationshipName Arcade function?

DaveK — Thu, 20 Feb 2020 19:01:47 GMT

Hi Xander Bakker,

I would like to show the fields for the layer as well as all of the fields for the related table within the popup.

Re: How to use the FeatureSetByRelationshipName Arcade function?

XanderBakker — Thu, 20 Feb 2020 19:06:07 GMT

Hi David Krady ,

Currently there is no support for returning a featureset, as you noticed. You will have to gather the information of each related feature and each field and this might make the expression a bit long and the visualization is limited since you cannot return HTML (yet).

Re: How to use the FeatureSetByRelationshipName Arcade function?

DaveK — Thu, 20 Feb 2020 19:15:05 GMT

Is it possible to extract a single field from the related table to show within the popup along with the layer attributes? Would you have an example on how to gather a related feature and field to display within the popup?

Re: How to use the FeatureSetByRelationshipName Arcade function?

XanderBakker — Fri, 21 Feb 2020 12:44:51 GMT

Hi David Krady ,

If you look at the discussion here: How to get attribute with last date modified from related table using Arcade you will see an example of hao to extract a single value.

The FeatureSetByRelationshipName returns a featureset and you can also loop through all related records to gather a list of data and present that in the pop-up as is described here: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables (see the second and following expressions).

You can also apply statistical functions (sum, min, max, mean, etc) on the featureset.