topic Arcade Expression FeatureSet By Association in ArcGIS Pro Questions

Arcade Expression FeatureSet By Association

Mohamed_Gamal — Mon, 06 Feb 2023 08:24:40 GMT

i am trying to get all content features and put their GlobalID inside new array and use this array later to filter the table or the feature class containing this features.

var contentRows = FeatureSetByAssociation($feature, "content"); var globalIds = []; var i = 0; for (var v in contentRows) { globalIds[i++] =v.globalId } var asset_Array=[27,26] var deviceClass = FeatureSetByName($datastore, "CommunicationsJunctionObject"); var devicesRows = Filter(deviceClass, "globalid in @globalIds"); return{'errorMessage':count(devicesRows)}

Error Message

Re: Arcade Expression FeatureSet By Association

JohannesLindner — Mon, 06 Feb 2023 12:51:13 GMT

I believe ArcGIS uses default values when it verifies Arcade expressions. That means that it often doesn't find anything with functions like FeaturesetByRelationshipName() and Filter() adn returns empty featuresets.

In your case, it returned an empty fs with FeaturesetByAssociation(), so your globalIDs array is empty, which leads to your query being "GlobalID IN ()" which is invalid.

Try guarding against empty featuresets:

Re: Arcade Expression FeatureSet By Association

Mohamed_Gamal — Mon, 06 Feb 2023 13:07:47 GMT

It works just fine, Thanks