topic Re: What SQL dialect is used for AGOL Feature Service definition queries? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/what-sql-dialect-is-used-for-agol-feature-service/m-p/1534636#M87896 <P>Thanks&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/159762">@ChrisUnderwood</a>.</P><P>What is meant by the word "workspace" in this context? Is a different AGOL FC/table considered to be a different workspace?</P><BLOCKQUOTE><P><A href="https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm" target="_self">Standardized SQL functions in ArcGIS Online</A></P><P>Standardized queries are not supported on joins between <STRONG>different workspaces</STRONG>.</P></BLOCKQUOTE><P><BR />For example, are Table_1 and Table_2 different workspaces?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_1-1725391318225.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/114209iA450D3F2B2F3A876/image-size/large?v=v2&amp;px=999" role="button" title="Bud_1-1725391318225.png" alt="Bud_1-1725391318225.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 03 Sep 2024 19:22:08 GMT Bud 2024-09-03T19:22:08Z What SQL dialect is used for AGOL Feature Service definition queries? https://community.esri.com/t5/arcgis-pro-questions/what-sql-dialect-is-used-for-agol-feature-service/m-p/1528357#M87582 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/760295">@JustinH</a>&nbsp;mentioned in&nbsp;<A href="https://community.esri.com/t5/data-management-questions/1-m-join-to-pull-feature-with-specific-attribute/m-p/1525211/highlight/true#M45344" target="_self">1:M Join to Pull feature with Specific Attribute information</A>:</P><BLOCKQUOTE><P><SPAN>I pull all of the data from an AGOL Feature Service that our organization is hosting.&nbsp;<BR /></SPAN></P></BLOCKQUOTE><P><SPAN>What SQL dialect is used in SQL expressions on&nbsp;AGOL Feature Service data?</SPAN></P><UL><LI><SPAN>Definition query</SPAN></LI><LI><SPAN>Select by Attributes</SPAN></LI><LI><SPAN>Any other SQL expressions in geoprocessing tools</SPAN></LI></UL> Wed, 28 Aug 2024 01:27:39 GMT https://community.esri.com/t5/arcgis-pro-questions/what-sql-dialect-is-used-for-agol-feature-service/m-p/1528357#M87582 Bud 2024-08-28T01:27:39Z Re: What SQL dialect is used for AGOL Feature Service definition queries? https://community.esri.com/t5/arcgis-pro-questions/what-sql-dialect-is-used-for-agol-feature-service/m-p/1529301#M87639 <P>Hello&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/351335">@Bud</a>&nbsp;, is "Standardized SQL" the answer you are looking for ?</P><P><A href="https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm" target="_blank" rel="noopener">https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm</A></P><P><EM>"<SPAN class="">ArcGIS Online</SPAN>&nbsp;requires developers to use standardized SQL queries when querying hosted feature layers."</EM></P><P>&nbsp;</P> Thu, 29 Aug 2024 11:07:43 GMT https://community.esri.com/t5/arcgis-pro-questions/what-sql-dialect-is-used-for-agol-feature-service/m-p/1529301#M87639 ChrisUnderwood 2024-08-29T11:07:43Z Re: What SQL dialect is used for AGOL Feature Service definition queries? https://community.esri.com/t5/arcgis-pro-questions/what-sql-dialect-is-used-for-agol-feature-service/m-p/1534636#M87896 <P>Thanks&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/159762">@ChrisUnderwood</a>.</P><P>What is meant by the word "workspace" in this context? Is a different AGOL FC/table considered to be a different workspace?</P><BLOCKQUOTE><P><A href="https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm" target="_self">Standardized SQL functions in ArcGIS Online</A></P><P>Standardized queries are not supported on joins between <STRONG>different workspaces</STRONG>.</P></BLOCKQUOTE><P><BR />For example, are Table_1 and Table_2 different workspaces?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_1-1725391318225.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/114209iA450D3F2B2F3A876/image-size/large?v=v2&amp;px=999" role="button" title="Bud_1-1725391318225.png" alt="Bud_1-1725391318225.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 03 Sep 2024 19:22:08 GMT https://community.esri.com/t5/arcgis-pro-questions/what-sql-dialect-is-used-for-agol-feature-service/m-p/1534636#M87896 Bud 2024-09-03T19:22:08Z