<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic ArcGIS Dynamic Layer Query - not supporting outStatistics on join in ArcGIS REST APIs and Services Questions</title>
    <link>https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-dynamic-layer-query-not-supporting/m-p/210626#M1042</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to run statistics on my service when a layer is joined to a dataLayer from a workspace, but it keeps on failing. &amp;nbsp;I've created a similar payload using the esri sample services here:&lt;/P&gt;&lt;P&gt;&lt;A class="link-titled" href="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab%2C+r_count&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=ancestry.Arab&amp;amp;groupByFieldsForStatistics=ancestry.Arab&amp;amp;outStatistics=%5B%7B%22onStatisticField%22%3A%22ancestry.Arab%22%2C%22statisticType%22%3A%22count%22%2C%22outStatisticFieldName%22%3A%22r_count%22%7D%5D&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html" title="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab%2C+r_count&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=ancestry.Arab&amp;amp;groupByFieldsForStatistics=ancestry.Arab&amp;amp;outStatistics=%5B%7B%22onStatisticField%22%3A%22ancestry.Arab%22%2C%22statisticType%22%3A%22count%22%2C%22outStatisticFieldName%22%3A%22r_count%22%7D%5D&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html"&gt;Query Dynamic Layer&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I remove the statistics parameter, then the query works as expected.&lt;/P&gt;&lt;P&gt;&lt;A class="link-titled" href="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=&amp;amp;groupByFieldsForStatistics=&amp;amp;outStatistics=&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html" title="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=&amp;amp;groupByFieldsForStatistics=&amp;amp;outStatistics=&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html"&gt;Query Dynamic Layer&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Anybody have any thoughts or insight into why this happens?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 26 Oct 2017 18:29:10 GMT</pubDate>
    <dc:creator>AlexThomas1</dc:creator>
    <dc:date>2017-10-26T18:29:10Z</dc:date>
    <item>
      <title>ArcGIS Dynamic Layer Query - not supporting outStatistics on join</title>
      <link>https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-dynamic-layer-query-not-supporting/m-p/210626#M1042</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to run statistics on my service when a layer is joined to a dataLayer from a workspace, but it keeps on failing. &amp;nbsp;I've created a similar payload using the esri sample services here:&lt;/P&gt;&lt;P&gt;&lt;A class="link-titled" href="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab%2C+r_count&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=ancestry.Arab&amp;amp;groupByFieldsForStatistics=ancestry.Arab&amp;amp;outStatistics=%5B%7B%22onStatisticField%22%3A%22ancestry.Arab%22%2C%22statisticType%22%3A%22count%22%2C%22outStatisticFieldName%22%3A%22r_count%22%7D%5D&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html" title="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab%2C+r_count&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=ancestry.Arab&amp;amp;groupByFieldsForStatistics=ancestry.Arab&amp;amp;outStatistics=%5B%7B%22onStatisticField%22%3A%22ancestry.Arab%22%2C%22statisticType%22%3A%22count%22%2C%22outStatisticFieldName%22%3A%22r_count%22%7D%5D&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html"&gt;Query Dynamic Layer&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I remove the statistics parameter, then the query works as expected.&lt;/P&gt;&lt;P&gt;&lt;A class="link-titled" href="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=&amp;amp;groupByFieldsForStatistics=&amp;amp;outStatistics=&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html" title="https://sampleserver6.arcgisonline.com/arcgis/rest/services/Census/MapServer/dynamicLayer/query?layer=%7B%22id%22%3A0%2C%22source%22%3A%7B%22dataSource%22%3A%7B%22leftTableSource%22%3A%7B%22mapLayerId%22%3A3%2C%22type%22%3A%22mapLayer%22%7D%2C%22rightTableSource%22%3A%7B%22dataSource%22%3A%7B%22dataSourceName%22%3A%22ancestry%22%2C%22workspaceId%22%3A%22CensusFileGDBWorkspaceID%22%2C%22type%22%3A%22table%22%7D%2C%22type%22%3A%22dataLayer%22%7D%2C%22leftTableKey%22%3A%22STATE_NAME%22%2C%22rightTableKey%22%3A%22State%22%2C%22joinType%22%3A%22esriLeftOuterJoin%22%2C%22type%22%3A%22joinTable%22%7D%2C%22type%22%3A%22dataLayer%22%7D%7D&amp;amp;where=1%3D1&amp;amp;text=&amp;amp;objectIds=&amp;amp;time=&amp;amp;geometry=&amp;amp;geometryType=esriGeometryEnvelope&amp;amp;inSR=&amp;amp;spatialRel=esriSpatialRelIntersects&amp;amp;relationParam=&amp;amp;outFields=ancestry.Arab&amp;amp;returnGeometry=false&amp;amp;maxAllowableOffset=&amp;amp;outSR=&amp;amp;returnIdsOnly=false&amp;amp;returnCountOnly=false&amp;amp;orderByFields=&amp;amp;groupByFieldsForStatistics=&amp;amp;outStatistics=&amp;amp;returnZ=false&amp;amp;returnM=false&amp;amp;returnDistinctValues=false&amp;amp;f=html"&gt;Query Dynamic Layer&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Anybody have any thoughts or insight into why this happens?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Oct 2017 18:29:10 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-dynamic-layer-query-not-supporting/m-p/210626#M1042</guid>
      <dc:creator>AlexThomas1</dc:creator>
      <dc:date>2017-10-26T18:29:10Z</dc:date>
    </item>
  </channel>
</rss>

