topic Re: Filter map layer and related tables in ArcGIS Experience Builder Questions

Filter map layer and related tables

JustinWolff — Mon, 04 Aug 2025 20:30:53 GMT

We have a hosted feature layer in AGO containing one (1) polygon feature class, and three (3) tables with multiple relationships:

Tracts (Polygon) -> 1:Many -> Tract Notes (Table), relationship fields OBJECTID -> TractGUID

Project (Table) -> 1:Many -> ProjectNotes (Table), relationship fields OBJECTID -> ProjectGUID

Project (Table) -> 1:Many -> Tracts (Polygon), relationship fields OBJECTID -> ProjectGUID

So one Tract may have multiple TractNotes records, one Project may have multiple ProjectNotes records, and one Project may have multiple Tract features.

In Experience Builder, I would like to filter the Project table on the 'Project Name' field, and have it also work against the Tracts polygons in the map. Ideall, the Edit widgets configured to add records to Tracts, TractNotes and ProjectNotes would default the ProjectGUID values in Tracts and ProjectNotes. We are currently using a Survey widget to add polygon features, pulling geometry and some attributes from another map layer, and an Edit widget to add records to the TractNotes and ProjectNotes tables. I'm hung up on the initial Project filter - how do I configure a Filter to work against related records? Based on what I'm finding elsewhere in Community this may not be an option? Thanks

Re: Filter map layer and related tables

Laura — Tue, 05 Aug 2025 20:41:51 GMT

I ran into a similar issue. I have a layer with two related tables, and I needed to filter based on the related records. To work around it, I created joined view layers for each table so they would have a spatial reference. This allowed me to zoom to and filter the data.

In my case, I used the Query widget, but the approach should be similar. I set up actions within the framework to Filter Data Records and Select Data Records, using the view layer as the trigger and the original polygon layer as the action target. That way, it would zoom to the correct feature and display the custom popup I configured on the polygon layer.

Re: Filter map layer and related tables

JustinWolff — Wed, 06 Aug 2025 13:31:45 GMT

Thank you, Laura, I think that's the route I'm going to have to go.

Re: Filter map layer and related tables

apgis16 — Wed, 28 Jan 2026 20:20:17 GMT

@Laura If using a join view, how do I use that layer in the widget so it filters on the map? The map has the original hosted feature layer in it, not the join view.

Re: Filter map layer and related tables

Laura — Wed, 28 Jan 2026 20:27:38 GMT

The view layer is trigger and the original layer is the action. You need a unique ID that is the same for each to tie them together.

Re: Filter map layer and related tables

apgis16 — Wed, 28 Jan 2026 20:53:06 GMT

I only see the option to select the trigger called "Data filtering changes" and the action be "pan to" or "zoom to"

Re: Filter map layer and related tables

Laura — Mon, 02 Feb 2026 14:00:38 GMT

Need to use query instead of the filter widget.

Re: Filter map layer and related tables

HannahG — Mon, 02 Feb 2026 08:34:51 GMT

Did you find a good solution @apgis16 ? I have the same issue and while I cannot make it work with a filter widget, a selection widget works.

Re: Filter map layer and related tables

mwartman_grey — Wed, 11 Mar 2026 15:07:54 GMT

The Feb 2026 ArcGIS Online update includes a new message action for Data in the Filter Widget. This filters related records and their parent records (or vice versa) across the entire ExB app which is very helpful.

See the section 'New message actions' in the blog post linked below:

https://www.esri.com/arcgis-blog/products/experience-builder/announcements/whats-new-in-arcgis-experience-builder-february-2026