Filter by Related Table

[West-d-gis]

I am looking at building a custom widget that will allow me to filter a geometry/feature layer by a search/filter on a related table. Does anyone know if there are existing custom widget that allows this functionality?

I understand a similar process can be pulled off with view layers, however we're looking at several hundred thousand table records and the users want to filter at a national scale.

If something does not already exist to do this, can anyone point me to good tutorials on getting started building a widget to add this functionality?

[AlixVezina]

Hi @West-d-gis ,

Related data is recognized within the Experience Builder data sources. When you configure Message actions between widgets, you can set Filter records. For example with the configuration below, when a Tree feature will be selected, it's related table records will also be selected.

This is available in ArcGIS Online and starting at Enteprise 11.4.

[West-d-gis]

Unfortunately, what we would want is a reverse of the points being the Trigger. We would want to filter by the related table and then have that go backward to the related feature class (in your example it would be the Tree Inspections as the Trigger for the filter and the action be the points). That did not seem possible in AGOL.

[AlixVezina]

Hi @West-d-gis , setting up the actions in reverse should also work in Experience Builder > with the selected related record filtering features from the parent layer!

[apgis16]

Can I use the filter widget to filter the parent record (polyline on the map) with a field that is in related record? If by creating a join view, how do I use that layer in the widget so it filters on the map?

[mwartman_grey]

@apgis16 , there is a new message action for the Filter Widget that does exactly this in the Feb 2026 ArcGIS Online update. 

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-exper...