FeatureSetByPortalItem in FieldMaps | "Object failed to load, unable to excecute task."
Accepted Solutions
Hi @DougBrowning, thanks for taking a look at this! I appreciate the suggestions.
I cleaned up the field request(s) with just the fields I need, and replaced the FeatureSetByRelationshipName() with the Filter(FeatureSetByName()) logic as suggested (shoutout to the ESRI Arcade-Expressions Github). Again, the script runs successfully within the Editor console in the web version, but fails to calculate anything in Field Maps mobile app (android). I'm using a known splicecase to evaluate the script in the Editor (Line 10).
Here is the revised code:
// Get All Tap features
var const_taps = FeatureSetByName($map, "LOOKUP1",['facilityid'],true)
//Get Vault Associated with Audit Record
//var vaults = FeatureSetByRelationshipName($feature, "crescentlink.sde.sdm_PathAccess") // Old Style, maybe bug?
var parent_ID = $feature.pathaccessguid
var parent_ID = Upper(parent_ID)
var parent_class = FeatureSetByName($map, "Auditable Vaults",['globalid'],true)
var vault = First(Filter(parent_class, 'globalid = @parent_ID')) // Production, based on audit record
//var vault = First(Filter(parent_class, 'pathaccessid = 31831')) // Testing Vault
//Get All Taps Intersecting Vault
var intersected_taps = Intersects(const_taps, Geometry(vault))
//Check for No Intersecting Taps
if(Count(intersected_taps) < 1){
Console("No Intersecting Taps. Returning NULL")
return null
}
//Get Splicecase(s) intersecting Taps
var const_cases = FeatureSetByName($map, "LOOKUP2",['splicepointid'],true)
var intersected_cases = Intersects(const_cases, Geometry(First(intersected_taps)))
//Check for multiple intersected splicecases
if(Count(intersected_cases) > 1){
Console("Multiple Splicecases Selected. Returning NULL")
return null
}
//Get Splicecase VaultID
var sp_vaults = Intersects(FeatureSetByName($map, "Auditable Vaults"),Geometry(First(intersected_cases)))
var sp_vault = First(sp_vaults)
//CONSOLE OUTPUTS
Console('CONST_TAPS: ' + First(const_taps))
Console('INTERSECTED TAPS: ' + First(intersected_taps))
Console('CONST CASES: ' + First(const_cases))
Console('INTERSECTED CASES: ' + First(intersected_cases))
Console('SP VAULT: ' + sp_vault)
return Text(sp_vault.pathaccessid)+'.1'This code doesn't even throw any errors in the troubleshooting log on the mobile app, but fails to calculate anything in the field it's applied to in the form (already verified that this field is a TEXT datatype). It's almost like it's returning <Null> as it even lets me submit the record (which would only be possible if the script ran?).
