Reference related tables using Arcade

Idea created by rtansley on Sep 27, 2017

Comment • 7

Implemented

Score710

+62 more

It would be great to let Arcade access information from related tables. For example for a popup, if you could click on a feature and use Arcade to loop through records in the related table and display that information. @ Kelly Gerrow BPriya K

7 Comments

a.hirschi-wyssesri-rw-esridist Sep 28, 2017 12:03 AM
What a great idea! Huge potential in here. I'd vote up a 100 times if I were allowed to ;-)
Like • Show 3 Likes3
Actions
bhanu_vd Oct 30, 2017 8:38 AM
I vote for this idea
Like • Show 0 Likes0
Actions
rozekc_washtenaw Mar 5, 2018 10:38 AM
An example use case is the Restaurant Inspections Collector template, you can have Arcade find the most recent related record so you can symbolize the Restaurant by the latest grade.
Like • Show 4 Likes4
Actions
- MGG_Beca @ rozekc_washtenaw on Nov 26, 2018 3:44 PM
  Or any Survey123 form with repeats - the field apps make heavy use of related records and actually using them in the ArcGIS Online/Enterprise ecosystem is currently difficult.
  Like • Show 0 Likes0
  Actions
xander_bakker Dec 11, 2018 7:48 AM
Part of the functionality is available in ArcGIS Online after the update of December 5th. Kelly Gerrow just published a blog about this: Overlapping Features in Pop-Ups Quick Introduction to Using FeatureSets with Arcade . This addresses accessing data from a different layer and performing an intersect to show this data in the pop-up window. In a blog that I published (in Spanish, sorry) the second example shows how you can access a table (that does not have to be related using a relationshipclass) and do some statistics on it:
Mejoras en Arcade en ArcGIS Online con la Actualización de 5 de diciembre del 2018

There are a couple of limitation:
- You can only use the FeatureSetBy* functions in the pop-up and in attribute rules (not for symbolizing). I assume this is due to performance considerations. Which I can imagne when you compare showing a pop-up (single action) to showing a map with multiple features (multiple actions on each pan and zoom). However, if your data resides in an EGDB and you would implement an attribute rule to create data in a field you could do this and visualize on that field, but I doubt that you should try this due to the same performance considerations.
- You don't seem to have access to __ATTACH (attachments) tables (or at least I wasn't able to get access to them)
Like • Show 4 Likes4
Actions
- xander_bakker @ xander_bakker on Dec 12, 2018 2:26 PM
  A little more details in this post: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables
  Like • Show 1 Like1
  Actions
dougbrowning Feb 7, 2019 2:52 PM
It would still be nice to just get the related records without doing all the calls and filters. Also still cannot use FeatureSet in attribute table, labels, or Symbology.

Also would be nice to be able to use the related records Count from Configure Attributes in the attribute table, symbology, and labels.

So I would say not yet Implemented.

The issue I cannot find a way to solve is somehow highlighting Features that do not have the proper number of related records. For us a user is not Done at a site until 3 related records are created. I would like to somehow flag these in Collector or a web map. So that any number of related records but 3 are flagged somehow. I have tried all kinds of ways including Ops dashboard and just cant get it. I want it to be dynamic so no joins or anything.

Thanks
Like • Show 3 Likes3
Actions

GeoNet

The Esri Community

Reference related tables using Arcade

Related Content

Recommended Content

Incoming Links