topic Arcade Filter a featureSet in ArcGIS Online Questions

Arcade Filter a featureSet

JessicaHendricks444 — Fri, 18 Apr 2025 17:06:05 GMT

We are working to visualize datasets for a Dashboard using a complex Arcade expression. However, we are stuck on the first Filter function of a featureSet. Can anyone offer suggestions??????

var quadTable = FeatureSetByPortalItem(portalUrl, itemId, 29, ["QuadInsp_GUID","FaunaPresent_MarshQuad"]);

var quadOysters = Filter(quadTable, "FaunaPresent_MarshQuad IN ('1')");

The "FaunaPresent_MarshQuad" field can have text values of "1", "1, 2", "1, 2, 3", etc. We want to find those records that have a "1" somewhere present in that field.

Many thanks!

Re: Arcade Filter a featureSet

MobiusSnake — Fri, 18 Apr 2025 17:14:39 GMT

Assuming you only have single-digit numbers, I think this would work:

FaunaPresent_MarshQuad LIKE '%1%'

If you have two-digit values it's going to be trickier.

Re: Arcade Filter a featureSet

JessicaHendricks444 — Fri, 18 Apr 2025 17:18:47 GMT

Ooh that does work. Is there a way to select multiple values in that statement? I.e., if we want all records with a "1" or a "2" in them?

Something like

FaunaPResent_MarshQuad LIKE '%1%' || FaunaPresent_MarshQuad LIKE '%2%'

Thanks so much!

Re: Arcade Filter a featureSet

KenBuja — Fri, 18 Apr 2025 17:30:37 GMT

You can have multiple LIKES, but you have to use "OR" not "||"

FaunaPResent_MarshQuad LIKE '%1%' OR FaunaPresent_MarshQuad LIKE '%2%'

Re: Arcade Filter a featureSet

JessicaHendricks444 — Fri, 18 Apr 2025 17:33:55 GMT

Thank you both so much!!