topic Re: Help with arcade expression in ArcGIS Pro Questions

Help with arcade expression

Robswann — Tue, 30 Aug 2022 14:22:49 GMT

I am trying to pull from a feature set the location by filtering it by the relationship ID. I have similar formulas that work fine, but for some reason I am having trouble with this one. I have the following, could someone please help? The below rule is working, but pulling the first row from attribute table. Thanks

var Land = FeatureSetByName($datastore, "Land", [ "Location","Name","County","School_District","ID"]);

VAR LOCATION = FILTER(LAND,"ID=$feature.ID")

FOR(VAR I IN LAND)
RETURN I.LOCATION

Re: Help with arcade expression

JillianStanford — Tue, 30 Aug 2022 15:21:55 GMT

Hi,

Do you mean to loop through the original dataset or the filtered dataset? Also, I'm not sure if the curly braces are required in Arcade.

https://developers.arcgis.com/arcade/guide/logic/#for-loops

Does the following work?

var Land = FeatureSetByName($datastore, "Land", [ "Location","Name","County","School_District","ID"]);

VAR LOCATION = FILTER(LAND,"ID=$feature.ID")

FOR(VAR I IN LOCATION ) {
RETURN I.LOCATION

}

Re: Help with arcade expression

JohannesLindner — Tue, 30 Aug 2022 15:26:11 GMT

You're telling your DBMS to use the literal SQL query "ID = $feature.ID". This isn't a valid where clause and so it fails.

What you want to do is store the $feature.ID in a variable and use the @ notation of Filter() to take care of the type formatting for you.

Also, you aren't looping over the filtered feature set, but over the whole table...

var Land = FeatureSetByName($datastore, "Land", [ "Location", "Name", "County", "School_District", "ID"]); var id = $feature.ID var related = Filter(Land,"ID=@id") var location = First(related) if(location == null) { // no related features found -> return a default value return null } // else return the related feature's ID return location.ID

Re: Help with arcade expression

Robswann — Tue, 30 Aug 2022 15:30:50 GMT

Very Helpful. Thank so much!