idea Allow exceptions to standardized query rules in ArcGIS Enterprise Ideas https://community.esri.com/t5/arcgis-enterprise-ideas/allow-exceptions-to-standardized-query-rules/idi-p/947204 <HTML><HEAD></HEAD><BODY><P><A href="https://geonet.esri.com/ideas/8551">ArcGIS Server standardized SQL queries</A>&nbsp;</P><P><A href="https://geonet.esri.com/ideas/10767">Allow standardize queries setting per service - not server</A>&nbsp;</P><P></P><P>These ideas have been open since 2013 and have not received any attention. If moving the standardized query setting to the service level is not something esri is interested in allowing then we need to make the standardized query rules customizable.&nbsp;</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Limitations of standardized queries<BR />Standardized queries are applied to the entire ArcGIS Server site; they cannot be enabled for some services and disabled for others.<BR />Standardized queries are not supported on joins between different workspaces. Additionally, database tables accessed through an OLE DB connection file are not supported. If your service data contains these sources, you'll need to use alternative methods for referencing your data.<BR />Subqueries as a where clause, for example, POP_2010 = (SELECT min(POP_2010) FROM counties are not supported.</P></BLOCKQUOTE><P></P><P>I think subqueries and <SPAN>database functions</SPAN>&nbsp;are a good option to start with since I would assume they are the most common reason to turn off standardized queries. Having a checkbox list of database functions to allow would be very helpful. And for subqueries an allowable template or a white list of queries is an option if it is not overly&nbsp;complicated.&nbsp;</P><P></P><P>It is really problematic to disable standardized queries because one service needs to use a subquery or function.&nbsp;</P></BODY></HTML> Tue, 30 May 2017 22:31:15 GMT stevegourley 2017-05-30T22:31:15Z Allow exceptions to standardized query rules https://community.esri.com/t5/arcgis-enterprise-ideas/allow-exceptions-to-standardized-query-rules/idi-p/947204 <HTML><HEAD></HEAD><BODY><P><A href="https://geonet.esri.com/ideas/8551">ArcGIS Server standardized SQL queries</A>&nbsp;</P><P><A href="https://geonet.esri.com/ideas/10767">Allow standardize queries setting per service - not server</A>&nbsp;</P><P></P><P>These ideas have been open since 2013 and have not received any attention. If moving the standardized query setting to the service level is not something esri is interested in allowing then we need to make the standardized query rules customizable.&nbsp;</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Limitations of standardized queries<BR />Standardized queries are applied to the entire ArcGIS Server site; they cannot be enabled for some services and disabled for others.<BR />Standardized queries are not supported on joins between different workspaces. Additionally, database tables accessed through an OLE DB connection file are not supported. If your service data contains these sources, you'll need to use alternative methods for referencing your data.<BR />Subqueries as a where clause, for example, POP_2010 = (SELECT min(POP_2010) FROM counties are not supported.</P></BLOCKQUOTE><P></P><P>I think subqueries and <SPAN>database functions</SPAN>&nbsp;are a good option to start with since I would assume they are the most common reason to turn off standardized queries. Having a checkbox list of database functions to allow would be very helpful. And for subqueries an allowable template or a white list of queries is an option if it is not overly&nbsp;complicated.&nbsp;</P><P></P><P>It is really problematic to disable standardized queries because one service needs to use a subquery or function.&nbsp;</P></BODY></HTML> Tue, 30 May 2017 22:31:15 GMT https://community.esri.com/t5/arcgis-enterprise-ideas/allow-exceptions-to-standardized-query-rules/idi-p/947204 stevegourley 2017-05-30T22:31:15Z Re: Allow exceptions to standardized query rules https://community.esri.com/t5/arcgis-enterprise-ideas/allow-exceptions-to-standardized-query-rules/idc-p/1103092#M2616 <P>sub-selects are a priority. especially with new association rules in UN, leveraging sub-selects would be very powerful.</P> Wed, 29 Sep 2021 14:30:37 GMT https://community.esri.com/t5/arcgis-enterprise-ideas/allow-exceptions-to-standardized-query-rules/idc-p/1103092#M2616 geonexusjames 2021-09-29T14:30:37Z Re: Allow exceptions to standardized query rules https://community.esri.com/t5/arcgis-enterprise-ideas/allow-exceptions-to-standardized-query-rules/idc-p/1287194#M3308 <P>Hi. This is still a pain point. As i've seen in the docu of ArcGis Enterprise 11, it is still only possible on site level to configure standardized queries.&nbsp;</P><P>Is there a roadmap to support a customization of this "feature" on service level? Or at least to except some service from it?</P> Tue, 09 May 2023 12:24:53 GMT https://community.esri.com/t5/arcgis-enterprise-ideas/allow-exceptions-to-standardized-query-rules/idc-p/1287194#M3308 SCS_ANST 2023-05-09T12:24:53Z