In Pro we can create a definition Query using SQL to only show those records that meet criteria in a relationship.
What I would like to try is to base symbols on a similar query. In symbology we can Set an Expression but it uses Arcade. Can anyone show me a query for Arcade that works like SQL query
This is the SQL Query that selects from a relationship. Values in Bold Italics are variables
<origin table attribute> IN (SELECT <related table attribute> FROM <related table name> WHERE <related table attribute> like '%<string>%')
How would I write this in Arcade?