Calculated Expression Not working to pull feature

DWebb — Thu, 09 Nov 2023 16:53:05 GMT

I am doing inspections and I'm trying to pull in the facility name in the inspection table from the related layer.

Here is the expression that I'm using, which displays when we test but not in the field map applications.

var sitename = FeatureSetByRelationshipName($feature,"L1GI_Inspection_Sites" , ['fse_name'])
var site = First(sitename)
if (!IsEmpty(site)) {
return site['fse_name']
} else {
return null
}

Re: Calculated Expression Not working to pull feature

marksm_macomb — Thu, 09 Nov 2023 20:18:59 GMT

A few other geonet posts have observed buggy things happening with FeatureSetByRelationshipName. I use the below expression using FeatureSetByID instead, with a filter to match primary key to foreign key and it works well for us:

var parent_id = $feature.ParentGUID_ var related_Manholes = FeatureSetById($datastore, "6",['GlobalID', 'FacilityID'], false) var parent_Manhole = First(Filter(related_Manholes, 'GlobalID = @parent_id')) if(parent_Manhole == null){ return } else { return parent_Manhole.FacilityID }

topic Calculated Expression Not working to pull feature in ArcGIS Field Maps Questions

Calculated Expression Not working to pull feature

Re: Calculated Expression Not working to pull feature