topic ArcGIS Online Arcade Expression: Query Results in Viewer? in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-online-arcade-expression-query-results-in/m-p/491709#M19061 <HTML><HEAD></HEAD><BODY><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">This maybe not be possible but trying anyway. I have a Map Service with geometry features published. Two of the columns are 'Zone1' and 'Zone2' with values like 'ABC' or 'DEF'. The values of 'ABC' or 'DEF' can be present in both columns in the same row.</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">There is also a static 'lookup table' with a column named ZONECLASS and values like 'ABC' or 'DEF'. The static table is also published as layer in the along with the layer with geometry. So far so good.</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">What I am trying to do is that inside ArcGIS Online's Arcade Expression, query the static table's layer and get that data displayed inside ArcGIS Online. The query works in the browser as:</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;"><A href="http://servicepath/MapServer/1/query?where=ZONECLASS=%ABC27&amp;outFields=DOCNAME" rel="nofollow noreferrer" style="color: #358daa; border: 0px; font-weight: inherit; text-decoration: none;">http://servicepath/MapServer/1/query?where=ZONECLASS=%ABC27&amp;outFields=DOCNAME</A></P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">But how to bring value of the DOCNAME field inside ArcGIS Online? I have built an expression as above url but that's just a string. I need to get the output.</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">Is that even possible? Any alternate solutions?</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">Thanks.</P></BODY></HTML> Tue, 29 May 2018 21:01:47 GMT IrfanClemson 2018-05-29T21:01:47Z ArcGIS Online Arcade Expression: Query Results in Viewer? https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-online-arcade-expression-query-results-in/m-p/491709#M19061 <HTML><HEAD></HEAD><BODY><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">This maybe not be possible but trying anyway. I have a Map Service with geometry features published. Two of the columns are 'Zone1' and 'Zone2' with values like 'ABC' or 'DEF'. The values of 'ABC' or 'DEF' can be present in both columns in the same row.</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">There is also a static 'lookup table' with a column named ZONECLASS and values like 'ABC' or 'DEF'. The static table is also published as layer in the along with the layer with geometry. So far so good.</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">What I am trying to do is that inside ArcGIS Online's Arcade Expression, query the static table's layer and get that data displayed inside ArcGIS Online. The query works in the browser as:</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;"><A href="http://servicepath/MapServer/1/query?where=ZONECLASS=%ABC27&amp;outFields=DOCNAME" rel="nofollow noreferrer" style="color: #358daa; border: 0px; font-weight: inherit; text-decoration: none;">http://servicepath/MapServer/1/query?where=ZONECLASS=%ABC27&amp;outFields=DOCNAME</A></P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">But how to bring value of the DOCNAME field inside ArcGIS Online? I have built an expression as above url but that's just a string. I need to get the output.</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">Is that even possible? Any alternate solutions?</P><P style="color: #242729; background-color: rgba(248, 248, 248, 0.6); border: 0px; margin: 0px 0px 1em;">Thanks.</P></BODY></HTML> Tue, 29 May 2018 21:01:47 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-online-arcade-expression-query-results-in/m-p/491709#M19061 IrfanClemson 2018-05-29T21:01:47Z Re: ArcGIS Online Arcade Expression: Query Results in Viewer? https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-online-arcade-expression-query-results-in/m-p/491710#M19062 <HTML><HEAD></HEAD><BODY><P>Currently it is not possible to query external data in the Arcade expression, you can only use the information present in the current record of the feature.&nbsp;</P></BODY></HTML> Tue, 29 May 2018 21:47:25 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-online-arcade-expression-query-results-in/m-p/491710#M19062 XanderBakker 2018-05-29T21:47:25Z Re: ArcGIS Online Arcade Expression: Query Results in Viewer? https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-online-arcade-expression-query-results-in/m-p/491711#M19063 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/migrated-users/4544">Irfan Clemson</A>‌ be sure to mark Xander's answer as correct!</P></BODY></HTML> Thu, 07 Jun 2018 14:12:38 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-online-arcade-expression-query-results-in/m-p/491711#M19063 Anonymous User 2018-06-07T14:12:38Z