Filter when Field Contains the Text in Arcade

JustinH — Mon, 09 Sep 2024 19:58:51 GMT

Hello-

I am currently trying to filter a dataset by using an expression in Dashboards. The expression does more than just this filter so I cannot use the handy dandy filter tool within elements.

What I want my expression to say is Filter(dataset, feature 'contains the text' "State").

It seems fairly simple but I am having a hard time figuring this out. I tried following some of the suggestions from jcarlson in this post:

Solved: Arcade Expression for field "includes" a value - Esri Community

However, I am not really sure how to integrate this Split + Includes or the Find workflow into my filter function.

Here is a more Specific Code:

// Filter the FeatureSet for "State Trust" in the FUNDING_SOURCE field using Includes var statelands = Filter(fs, Includes('FUNDING_SOURCE', 'State Trust'))

TIA!

Re: Filter when Field Contains the Text in Arcade

KenBuja — Mon, 09 Sep 2024 20:33:59 GMT

You can use the "Like" operator in the sql statement

filter(fs, "FUNDING_SOURCE Like '%State%'")

Re: Filter when Field Contains the Text in Arcade

JustinH — Mon, 09 Sep 2024 20:39:55 GMT

YES! Thank you so much!

topic Re: Filter when Field Contains the Text in Arcade in ArcGIS Dashboards Questions

Filter when Field Contains the Text in Arcade

Re: Filter when Field Contains the Text in Arcade

Re: Filter when Field Contains the Text in Arcade