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.