Hello Everyone,
Just trying to inquire if there is a way to convert an SQL Definition Query Expression (originally set up in ArcMap with related tables) into an AGO / PORTAL Web Map environment with published services.
The following expression takes parcel features and selects them by a particular activity from tables in a two level relationship class. This function varies according to each activity type required.
PAMS_PIN in (select PAMS_PIN from dep.dep.Cad_TL_PINumbers_Composite where PI_Number in (select PI_Number from dep.dep.Cad_TL_Activities where Activity_Class_Code = 'TDG'))
We would like to adapt this to newly published services for the parcels and the related tables using a spatial filter on the service. We know there is an Arcade expression feature in the Change Style option, but that does seem to have access to both table attributes. Also, is there a solution via AGO Assistant?
Here is a screen shot for the related tables and the associated GIS layer.
![Capture.PNG Capture.PNG](https://community.esri.com/t5/image/serverpage/image-id/37119i6F382063C2E2BD6C/image-size/small?v=v2&px=200)