topic Re: Arcade Pop-up return multiple values in ArcGIS Enterprise Questions

Arcade Pop-up return multiple values

BlueSky17 — Mon, 04 Dec 2023 18:15:32 GMT

Hello,

How to write a simple query in Arcade that would return multiple OBJECIDs....

in SQL in would be:

Objectid in (4538,41246,4002,4104,41228,36024,103255,36031)

How would my expression look like in Arcade?

I know it's a simple expression but found no help using Arcade tutorials.

Thanks.

Re: Arcade Pop-up return multiple values

DavidPike — Mon, 04 Dec 2023 20:48:47 GMT

https://developers.arcgis.com/arcade/function-reference/array_functions/#includes

Not sure your exact requirement but you could maybe keep SQL and use Filter()

var fs = $map.myFeature return Filter(fs, 'OBJECTID IN (1,2,3,4)')

https://developers.arcgis.com/arcade/function-reference/featureset_functions/#filter

Re: Arcade Pop-up return multiple values

BlueSky17 — Mon, 04 Dec 2023 22:06:08 GMT

Thank you for your response. Actually, I realized I don't have ObjectID field, instead I am using FacilityID.

So, now my expression looks like:

var fs = featuresetbyname($datastore, "Meter Box") RETURN filter(fs, 'facilityid in ("B07371314","B22661311")')

...but not having luck with it since I am getting this error:

Execution Error:Filter cannot accept this parameter type

I did take a look at the link you provided but it's all very vague. What I am trying to achieve is a very simple query but since arcade is a new language, I can't even find any similar example. But anyway, thank you for your help.

Re: Arcade Pop-up return multiple values

DavidPike — Mon, 04 Dec 2023 22:22:48 GMT

can you return fs and see what type it is. Maybe it's a feature collection. Have you tried Featuresetbyportalitem?

Re: Arcade Pop-up return multiple values

KenBuja — Tue, 05 Dec 2023 15:59:45 GMT

The Filter function's SQL syntax is very picky with quotes. Try this

var fs = featuresetbyname($datastore, "Meter Box") RETURN filter(fs, "facilityid in ('B07371314','B22661311')")