topic How to use Arcade to filter a list of related features based on an attribute in ArcGIS Pro Questions

How to use Arcade to filter a list of related features based on an attribute

cepotts — Thu, 06 Mar 2025 21:24:42 GMT

I hope this is the right place to post this.

From searching around it appears that you cannot dynamically display a count of related features on a label or map tip, but the workaround is to write the information to a field, and then use that within the necessary expressions.

I can successfully write the total number of related features to a field with the following code:

var relatedFeatures = FeatureSetByRelationshipName($feature, "<relationship_class_name>") return Count(relatedFeatures)

That works great and returns a total of 5, which is how many features are related in the one feature that I am testing this on. The image below shows the 5 related features.

However, the cable in that list is a sub-relation, and I don't want to include that feature in my count. In this particular example, I want the final count to show as 4. I was attempting to use the Filter() function to accomplish this, but I keep running into an invalid where clause error when adding the second line shown in the code below:

var relatedFeatures = FeatureSetByRelationshipName($feature, "<relationship_class_name>") var filteredFeatures = Filter(relatedFeatures, "Data Type != 'cable'") return Count(filteredFeatures)

I have attempted too many variations to recall. Any tips to point me in the right direction? I've been scouring through Google and ChatGPT and all of the examples returned lead me to exactly what I have written above.

Thanks!

Re: How to use Arcade to filter a list of related features based on an attribute

cepotts — Thu, 06 Mar 2025 21:23:06 GMT

Here is the actual error message:

Re: How to use Arcade to filter a list of related features based on an attribute

KenBuja — Fri, 07 Mar 2025 14:16:47 GMT

You have to use "<>" instead of "!=" in SQL statements

var filteredFeatures = Filter(relatedFeatures, "Data Type <> 'cable'")

Re: How to use Arcade to filter a list of related features based on an attribute

cepotts — Fri, 07 Mar 2025 14:21:00 GMT

Thank you for the response. That is one of the variations that I tried. It still returns the same message.

Re: How to use Arcade to filter a list of related features based on an attribute

KenBuja — Fri, 07 Mar 2025 14:27:20 GMT

You also have a space in the field name, which is probably its alias. Use the actual field name.

Re: How to use Arcade to filter a list of related features based on an attribute

cepotts — Fri, 07 Mar 2025 14:34:55 GMT

Thank you! I did try that in other variations, but it was likely in completely different things that I was trying at the time. I probably also still had the "!=" operator in there when attempting it. Much appreciated!