topic Re: Arcade - return field from related layer in ArcGIS Online Questions

Arcade - return field from related layer

LylianAvero — Wed, 13 Oct 2021 15:35:19 GMT

Hi!

I need help with Arcade expression. I have polygon layer and related tables that are related based on these fields: (Global_ID=ReferenceID)

In the attribute table for the related table, I'd like to return a field value from related polygon layer

Thank you in advance!!

Re: Arcade - return field from related layer

JohannesLindner — Wed, 13 Oct 2021 15:47:52 GMT

// load your polygon featureset // https://developers.arcgis.com/arcade/function-reference/data_functions/#featuresetbyname var polygon_fs = FeatureSetByName(...) // filter your polygons var ref_id = $feature.ReferenceID var polygon_filter = Filter(polygon_fs, "Global_ID = @ref_id") // return the attribute if(Count(polygon_filter) > 0) { return First(polygon_filter).Attribute } return null

Re: Arcade - return field from related layer

jcarlson — Wed, 13 Oct 2021 15:55:49 GMT

Is the relate 1:1 or 1:M? The expression may be more or less complex depending on that. Also, what is the context in which you're using this? Certain profiles (symbology, etc) have limitations on what functions are available to you.

Take a look at the expression FeatureSetByRelationshipName. This will return all related features, and individual features and attributes can be accessed directly through the resulting FeatureSet.

In the Expression Builder, you can see related records at the bottom of the $feature globals:

From there, you can select the particular relation (if there are multiple) that you'd like to bring into your expression.

Re: Arcade - return field from related layer

LylianAvero — Wed, 13 Oct 2021 15:58:11 GMT

Thank you so much, it worked! I was missing "Count" part

Re: Arcade - return field from related layer

KelseySmuczynski — Tue, 26 Apr 2022 19:24:31 GMT

This worked for me initially, but when I returned the next day to continue populating for other fields I received an error: "Execution Error: Cannot read properties of null (reading 'toString')". I think the issue is stemming from the filter variable -- somehow the GlobalID and GUID are not matching? Or something is null somewhere? Do you have any ideas on how best to resolve the issue? Any help would be appreciated. Below is the code I am running.

var wells_fs=FeatureSetByName($map,"Wellsites2")
var ref_guid= $feature.GUID
var wells_filter = Filter(wells_fs, "GlobalID = @ref_guid")

if(Count(wells_filter) > 0) {
return First(wells_filter).name
}
return null

Re: Arcade - return field from related layer

JohannesLindner — Wed, 27 Apr 2022 06:12:17 GMT

The filter query is OK. But you are right, the problem is related to the filter query and yes, something is null somewhere.

This is probably caused by null values in $feature.GUID.

When you execute this expression for a feature whose GUID is not in RelatedTable.GlobalID (but not null), Filter() returns an empty feature set, which is the reason for the empty check before accessing the First() element (better way in the code below).

When you execute the expression for a feature whose GUID is null, Filter() returns null and the expression fails on anything using that result, e.g. Count() or First().

So you just need another check at the top of the expression:

var ref_guid= $feature.GUID if(ref_guid == null) { // there can be no related features return null } var wells_fs=FeatureSetByName($map,"Wellsites2") var wells_filter = Filter(wells_fs, "GlobalID = @ref_guid") var well = First(wells_filter) if(well == null) { // wells_filter is empty, no related features found return null } return well.name