topic Re: Arcade - Get related information from feature in ArcGIS Online Questions

Arcade - Get related information from feature

MarcoPoetsch — Wed, 12 Oct 2022 06:56:34 GMT

Hi there,

I'm trying to get information from a table to a feature based on a related field.
The relationship is defined by a GUID field.

So basically I have a polygon layer called "Parcel" with a field for GlobalID. Then there is a table ("Permit") with additional information to this parcel. This "Permit" table has a field with ParcelID (= GlobalID from Parcel). There might be more than one matching permits to a parcel.

Is there a way I can configure the popup of the parcel in such a way that I can get some of the related fields from the permit table?

Just a note: There is no relationship configured (no relationship class has been setup)

Re: Arcade - Get related information from feature

JohannesLindner — Wed, 12 Oct 2022 08:48:02 GMT

Without a relationship class, you have to do the filtering yourself:

// load the permit table var all_permits = FeatureSetByPortalItem(...) // get the permits that belong to the parcel var parcel_id = $feature.GlobalID var parcel_permits = Filter(all_permits, "ParcelID = @parcel_id") // return a default value if no permits were found if(First(parcel_permits) == null) { return "No permits found for this parcel" } // build your output var output = [] for(var p in parcel_permits) { var line = `Permit ${p.PermitNumber}, issued on ${p.PermitDate} to ${p.PermitOwner}` Push(output, line) } // conctenate and return return Concatenate(output, TextFormatting.NewLine)

Re: Arcade - Get related information from feature

DougBrowning — Thu, 13 Oct 2022 14:22:41 GMT

Anyone know if there are plans to add a where clause to the FeatureSet calls like search cursor and other tools? I have posted it before but never a response.

The issue I have is some of my layers are 100K+ records. I know there is only the one record that matches my query but I have to grab all 100K then filter for the 1. With 30+ expressions in my popup it grinds to a halt.

Just add the filter to the call like this

FeatureSetByName(featureSetCollection, title, fields?, includeGeometry?, FilterQuery)

It would speed maps way up and maybe even make FeatureSet fast enough to enable it in symbology.

thank you

Re: Arcade - Get related information from feature

JohannesLindner — Fri, 14 Oct 2022 05:23:36 GMT

Sounds like a good enhancement, I just kudo'd your idea about this.

I'm not aware of any plans in this regard, but the ESRI staff in the Arcade related ideas isn't very communicative.

Re: Arcade - Get related information from feature

MarcoPoetsch — Mon, 17 Oct 2022 02:35:29 GMT

Genius. Thanks!

Re: Arcade - Get related information from feature

Bud — Thu, 27 Oct 2022 14:26:31 GMT

Can you provide a link to your idea?

Re: Arcade - Get related information from feature

DougBrowning — Thu, 27 Oct 2022 14:33:15 GMT

thanks i should have posted it.

https://community.esri.com/t5/arcgis-online-ideas/add-a-sql-clause-to-the-featureset-tool-calls/idi-p/1137871