Arcade with Related Records Problem in Enterprise Webmap

JamesFaron — Mon, 09 Mar 2020 18:03:06 GMT

I am having an issue with Arcade fetching related records when using a FeatureServer layer in the WebMap. The code:

var tbl = FeatureSetByName($datastore,"Raptor_Protection_Repeat");
var code = $feature.GUID;
var sql = "GUID = '" + code + "'";
Console(code);
Console(sql);
var related_data = Filter(tbl, sql);
var cnt = Count(related_data);
Console(cnt);
var result = cnt + " related records";
if (cnt > 0) {
// loop through related records
for (var row in related_data) {
// read some data and create the line you want
var line = TextFormatting.NewLine + " - " + row.PROTECTION;
// add the line to the result
result += line;
}
} else {
result = "No related records:";
}
// return the result
return result;

This works as expected if the layer in the Map is https://myserver.com/arcgis/rest/services/Raptor_Protection/Raptor_Protection/MapServer/0

But for this application, I need https://myserver.com/arcgis/rest/services/Raptor_Protection/Raptor_Protection/FeatureServer/0

When I try the above code as an arcade expression on the FeatureServer layer, I get the following error:

Execution Error:Feature Not Found

The console produces the count and sql as expected. It seems to fail on loop, specifically "var row in related_data".

In Dev tools (chrome) I see the following error: /portal/jsapi/jsapi4/:346 [esri.tasks.support.optimizedFeatureSet] convertToFeatureSet:unknown-geometry [object Object]

Any insight here would be greatly appreciated!

Thanks,

Jim Faron

topic Arcade with Related Records Problem in Enterprise Webmap in Developers Questions

Arcade with Related Records Problem in Enterprise Webmap