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!

[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.

[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!

[KenBuja · Accepted solution]

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

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

[JessicaHendricks444]

Thank you both so much!!