nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade Filter a featureSet

JessicaHendricks444

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!

Find more posts tagged with

Arcade

Accepted answers

kenbuja

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

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

All comments

JessicaHendricks444

Thank you both so much!!

kenbuja

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

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

JessicaHendricks444

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!

MobiusSnake

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.