https://community.esri.com/t5/arcgis-online-ideas/virtual-sql-attributes-in-arcgis-online/idi-p/1359358 <P>It would be great to be able to create <U>virtual SQL attributes</U> in AGOL.&nbsp;It would be similar to Arcade expressions, but the calculated columns would be exportable and viewable in the attribute table. It would take advantage of the power &amp; efficiency of SQL and would be as easy to set up as a definition query.</P><P>Similar to this&nbsp;<U>ArcGIS Pro</U> idea:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/virtual-attributes-ad-hoc/idi-p/1276471" target="_self">Virtual Attributes (ad hoc)</A></P><P>Related, but different:</P><UL><LI><A href="https://community.esri.com/t5/arcgis-online-ideas/have-arcade-expressions-become-real-fields-on/idc-p/1359346" target="_self">Have Arcade expressions become real fields on export</A></LI><LI><A href="https://community.esri.com/t5/arcgis-web-appbuilder-questions/can-i-export-derived-attribute-fields-created-with/td-p/189614" target="_self">Can I export derived attribute fields created with Arcade?</A></LI><LI><A href="https://community.esri.com/t5/developers-questions/save-attribute-expression-as-field-when-export/td-p/529668" target="_self">Save attribute expression as field when export</A></LI><LI><A href="https://community.esri.com/t5/arcgis-online-ideas/support-for-attribute-rules-in-arcgis-online/idi-p/935824" target="_self">Support for Attribute rules in ArcGIS Online</A></LI><LI><A href="https://community.esri.com/t5/arcgis-online-questions/arcade-calculated-field-does-not-show-up-when/td-p/45659" target="_self">Arcade calculated field does not show up when export to CSV from WAB attribute table</A></LI><LI><A href="https://community.esri.com/t5/developers-ideas/enable-arcade-functions-for-labels-and-symbols/idi-p/1223708" target="_self">Enable Arcade functions for Labels and Symbols using related tables</A></LI><LI><A href="https://community.esri.com/t5/arcgis-online-ideas/update-arcade-profiles-to-include-visualization/idi-p/1243517" target="_self">Update Arcade Profiles to include Visualization (symbology) based off related records</A></LI></UL> Thu, 14 Dec 2023 18:43:56 GMT Bud 2023-12-14T18:43:56Z https://community.esri.com/t5/arcgis-online-ideas/virtual-sql-attributes-in-arcgis-online/idi-p/1359358 <P>It would be great to be able to create <U>virtual SQL attributes</U> in AGOL.&nbsp;It would be similar to Arcade expressions, but the calculated columns would be exportable and viewable in the attribute table. It would take advantage of the power &amp; efficiency of SQL and would be as easy to set up as a definition query.</P><P>Similar to this&nbsp;<U>ArcGIS Pro</U> idea:&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/virtual-attributes-ad-hoc/idi-p/1276471" target="_self">Virtual Attributes (ad hoc)</A></P><P>Related, but different:</P><UL><LI><A href="https://community.esri.com/t5/arcgis-online-ideas/have-arcade-expressions-become-real-fields-on/idc-p/1359346" target="_self">Have Arcade expressions become real fields on export</A></LI><LI><A href="https://community.esri.com/t5/arcgis-web-appbuilder-questions/can-i-export-derived-attribute-fields-created-with/td-p/189614" target="_self">Can I export derived attribute fields created with Arcade?</A></LI><LI><A href="https://community.esri.com/t5/developers-questions/save-attribute-expression-as-field-when-export/td-p/529668" target="_self">Save attribute expression as field when export</A></LI><LI><A href="https://community.esri.com/t5/arcgis-online-ideas/support-for-attribute-rules-in-arcgis-online/idi-p/935824" target="_self">Support for Attribute rules in ArcGIS Online</A></LI><LI><A href="https://community.esri.com/t5/arcgis-online-questions/arcade-calculated-field-does-not-show-up-when/td-p/45659" target="_self">Arcade calculated field does not show up when export to CSV from WAB attribute table</A></LI><LI><A href="https://community.esri.com/t5/developers-ideas/enable-arcade-functions-for-labels-and-symbols/idi-p/1223708" target="_self">Enable Arcade functions for Labels and Symbols using related tables</A></LI><LI><A href="https://community.esri.com/t5/arcgis-online-ideas/update-arcade-profiles-to-include-visualization/idi-p/1243517" target="_self">Update Arcade Profiles to include Visualization (symbology) based off related records</A></LI></UL> Thu, 14 Dec 2023 18:43:56 GMT https://community.esri.com/t5/arcgis-online-ideas/virtual-sql-attributes-in-arcgis-online/idi-p/1359358 Bud 2023-12-14T18:43:56Z