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; } } }

Convert sql query to Arcade Expression

JoshLay1

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

Find more posts tagged with

Desktop

Accepted answers

ryanuthoff

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)

All comments

Tim-Woodfield

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.

JoshLay1

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

ryanuthoff

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

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.