https://community.esri.com/t5/arcgis-pro-ideas/dynamic-feature-layer-for-replacing-values-in-agol/idi-p/1528389 <P>It's my understanding that AGOL data is limited in ArcGIS Pro because database views and query layers are not supported.</P><P>For example,&nbsp;<A href="https://community.esri.com/t5/user/viewprofilepage/user-id/760295" target="_blank" rel="noopener">@JustinH</A><SPAN>'s requirement in&nbsp;</SPAN><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><SPAN>&nbsp;(AGOL Feature Service that is hosted).</SPAN></P><P>It would be ideal to dynamically query AGOL data in Pro rather than export to a file geodatabase or mobile geodatabase. An example of a dynamic query in a feature layer would be: replace values in a field on the fly—replace nulls with zeros (or zeros with nulls).</P><P>Could dynamic value replacement functionality be added to one of the existing <A href="https://community.esri.com/t5/arcgis-pro-ideas/consistent-visible-sql-expressions-and-query/idc-p/1366709/highlight/true#M27874" target="_self">feature layer geoprocessing tools</A>, such as Make Query Table?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1724812047095.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/113698i911EFE272E855B4E/image-size/large?v=v2&amp;px=999" role="button" title="Bud_0-1724812047095.png" alt="Bud_0-1724812047095.png" /></span></P><P>&nbsp;</P> Sat, 31 Aug 2024 04:06:38 GMT Bud 2024-08-31T04:06:38Z https://community.esri.com/t5/arcgis-pro-ideas/dynamic-feature-layer-for-replacing-values-in-agol/idi-p/1528389 <P>It's my understanding that AGOL data is limited in ArcGIS Pro because database views and query layers are not supported.</P><P>For example,&nbsp;<A href="https://community.esri.com/t5/user/viewprofilepage/user-id/760295" target="_blank" rel="noopener">@JustinH</A><SPAN>'s requirement in&nbsp;</SPAN><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><SPAN>&nbsp;(AGOL Feature Service that is hosted).</SPAN></P><P>It would be ideal to dynamically query AGOL data in Pro rather than export to a file geodatabase or mobile geodatabase. An example of a dynamic query in a feature layer would be: replace values in a field on the fly—replace nulls with zeros (or zeros with nulls).</P><P>Could dynamic value replacement functionality be added to one of the existing <A href="https://community.esri.com/t5/arcgis-pro-ideas/consistent-visible-sql-expressions-and-query/idc-p/1366709/highlight/true#M27874" target="_self">feature layer geoprocessing tools</A>, such as Make Query Table?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1724812047095.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/113698i911EFE272E855B4E/image-size/large?v=v2&amp;px=999" role="button" title="Bud_0-1724812047095.png" alt="Bud_0-1724812047095.png" /></span></P><P>&nbsp;</P> Sat, 31 Aug 2024 04:06:38 GMT https://community.esri.com/t5/arcgis-pro-ideas/dynamic-feature-layer-for-replacing-values-in-agol/idi-p/1528389 Bud 2024-08-31T04:06:38Z