topic Editing sql in a query layer published as a map service in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/editing-sql-in-a-query-layer-published-as-a-map/m-p/458343#M17746 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I've made a <A href="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-layer.htm">query layer</A>&nbsp;based on some MSSQL Server tables which I've published as a map service. Now I'm wondering if it's possible to edit the sql defining the query layer via the REST API of the map service. I'd like users of a web app to tweak some parameters such as date range, which would in turn edit the sql statement.</P><P></P><P>Any tips as to whether this is do-able?</P><P></P><P>Thanks,</P><P>Rowan</P></BODY></HTML> Thu, 27 Oct 2016 10:00:16 GMT RowanWinsemius 2016-10-27T10:00:16Z Editing sql in a query layer published as a map service https://community.esri.com/t5/arcgis-enterprise-questions/editing-sql-in-a-query-layer-published-as-a-map/m-p/458343#M17746 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I've made a <A href="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-layer.htm">query layer</A>&nbsp;based on some MSSQL Server tables which I've published as a map service. Now I'm wondering if it's possible to edit the sql defining the query layer via the REST API of the map service. I'd like users of a web app to tweak some parameters such as date range, which would in turn edit the sql statement.</P><P></P><P>Any tips as to whether this is do-able?</P><P></P><P>Thanks,</P><P>Rowan</P></BODY></HTML> Thu, 27 Oct 2016 10:00:16 GMT https://community.esri.com/t5/arcgis-enterprise-questions/editing-sql-in-a-query-layer-published-as-a-map/m-p/458343#M17746 RowanWinsemius 2016-10-27T10:00:16Z Re: Editing sql in a query layer published as a map service https://community.esri.com/t5/arcgis-enterprise-questions/editing-sql-in-a-query-layer-published-as-a-map/m-p/458344#M17747 <HTML><HEAD></HEAD><BODY><P>You can probably take advantage of <A href="http://resources.arcgis.com/en/help/arcgis-rest-api/#/Dynamic_Layer_Table/02r3000000q0000000/">dynamic layers</A>&nbsp;to pass in your own layer definition.</P></BODY></HTML> Thu, 27 Oct 2016 21:39:54 GMT https://community.esri.com/t5/arcgis-enterprise-questions/editing-sql-in-a-query-layer-published-as-a-map/m-p/458344#M17747 JonathanQuinn 2016-10-27T21:39:54Z