topic Re: Convert sql query to Arcade Expression in ArcGIS Pro Questions

Convert sql query to Arcade Expression

JoshLay1 — Mon, 19 May 2025 19:08:48 GMT

I have a simple sql expression used to filter on a layer in ArcGIS Pro

Field1 = 'Open' AND Field2 = 'LP' AND Field3 IN (10, 11, 12, 13, 14)

I would like to convert it to an Arcade Expression for use in a Velocity filter. Below is what I have come up with so far but it is returning some syntax errors.

$feature.Field1 = 'Open' && $feature.Field2 = 'LP' && $feature.Field3 IN (10, 11, 12, 13, 14)

Does anyone have suggestions how to convert the sql query to a arcade expression?

Thanks

Re: Convert sql query to Arcade Expression

RyanUthoff — Mon, 19 May 2025 19:32:43 GMT

The Arcade expression below might work. I think you'll need double equal signs. And the syntax for "IN" is a little different in Arcade. https://developers.arcgis.com/arcade/function-reference/array_functions/#includes

$feature.Field1 == 'Open' && $feature.Field2 == 'LP' && Includes([10, 11, 12, 13, 14], $feature.Field3)

Re: Convert sql query to Arcade Expression

JoshLay1 — Tue, 20 May 2025 18:08:09 GMT

The Arcade Expression you provided works perfectly. Thanks for taking time to solve my problem.

Re: Convert sql query to Arcade Expression

Tim-Woodfield — Fri, 05 Dec 2025 23:26:54 GMT

Would Includes() work in a data expression with the Filter() function? I would be trying to convert the "=" to SQL IN to account for a comma separated list.

Filter(project_table, `Contractor_Assigned = '${user_company}'`)

I don't have the full array list of possible values to compare to with Includes() but have been trying to use Distinct() to create it from the field.