https://community.esri.com/t5/arcgis-online-questions/convert-definition-query-expression-for-use-in-ago/m-p/1156832#M45061 <P>Hello Everyone,</P><P>Just trying to inquire if there is a way to convert an <STRONG>SQL Definition Query Expression</STRONG> (originally set up in ArcMap with related tables) into an <STRONG>AGO / PORTAL Web Map</STRONG> environment with published services.</P><P>The following expression takes parcel features and selects them by a particular activity from tables in a two level relationship class.&nbsp; This function varies according to each activity type required.</P><LI-CODE lang="sql">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'))</LI-CODE><P>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&nbsp;<FONT color="#808080"><STRONG>Change Style</STRONG></FONT> option, but that does seem to have access to both table attributes. Also, is there a solution via <FONT color="#808080"><STRONG>AGO Assistant</STRONG></FONT>?</P><P>Here is a screen shot for the related tables and the associated GIS layer.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 200px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/37119i6F382063C2E2BD6C/image-size/small?v=v2&amp;px=200" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Wed, 23 Mar 2022 16:43:02 GMT EmmanuelJohn 2022-03-23T16:43:02Z https://community.esri.com/t5/arcgis-online-questions/convert-definition-query-expression-for-use-in-ago/m-p/1156832#M45061 <P>Hello Everyone,</P><P>Just trying to inquire if there is a way to convert an <STRONG>SQL Definition Query Expression</STRONG> (originally set up in ArcMap with related tables) into an <STRONG>AGO / PORTAL Web Map</STRONG> environment with published services.</P><P>The following expression takes parcel features and selects them by a particular activity from tables in a two level relationship class.&nbsp; This function varies according to each activity type required.</P><LI-CODE lang="sql">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'))</LI-CODE><P>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&nbsp;<FONT color="#808080"><STRONG>Change Style</STRONG></FONT> option, but that does seem to have access to both table attributes. Also, is there a solution via <FONT color="#808080"><STRONG>AGO Assistant</STRONG></FONT>?</P><P>Here is a screen shot for the related tables and the associated GIS layer.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 200px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/37119i6F382063C2E2BD6C/image-size/small?v=v2&amp;px=200" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Wed, 23 Mar 2022 16:43:02 GMT https://community.esri.com/t5/arcgis-online-questions/convert-definition-query-expression-for-use-in-ago/m-p/1156832#M45061 EmmanuelJohn 2022-03-23T16:43:02Z