Hello! I’m working with a 1:M relationship between two feature classes in an ArcGIS Enterprise 11.3 environment. Layers are published through ArcGIS Server, brought into ArcGIS Portal, and consumed using Map Viewer and Field Maps.
- Parent Layer: WNV_StagnantWaterSites (Point feature layer – represents the general location of a stagnant water site)
- Child Table: WNV_SiteVisits (Also a point feature layer – represents the more specific location where sampling occurred during a related site visit)
The relationship is based on GlobalID (parent) → ParentGUID (child).
The parent layer includes a field called “Inactive”, which indicates whether a site is active:
- "0" = Active (No)
- "1" = Inactive (Yes)
In my web map, I’ve applied a filter to the parent layer to only show active sites (Inactive = '0'), and that works perfectly.
I’d like to apply the same logic to the related WNV_SiteVisits table, so it only shows point site visits related to the active parent site. However, since the “Inactive” field exists only in the parent layer, and Arcade can’t be used to reference related records in layer filters or symbology, I’m running into a roadblock.
I was hoping I could use an Arcade expression in the layer’s filter view, but it seems filters in Map Viewer only allow basic expressions using dropdown options. I would think in most 1:M relationships—especially with spatial child features, you’d want child records filtered out if their parent was filtered/excluded from the map view.
So far, I’ve explored almost every setting in Map Viewer, but I can’t find a way to do this. Of course, I could be missing something obvious lol!
Has anyone figured out a way to do this kind of filtering in map viewer?
