Filtering Points Based on Related Table Field in AGOL

[JohnThomas6]

I have a points layer in ArcGIS Online with a related table that lists multiple interventions for each point (e.g., Striping, Signage, Lighting). The relationship is one-to-many (PointID → Interventions).

The related records display correctly, but I can’t figure out how to create a filter so I can locate all points with a certain intervention (for example, all points that need Striping).

• Do filters in AGOL only work on fields in the primary feature layer?

• Is it possible to filter points by values stored in the related table?

• If not, what’s the recommended workflow — duplicating intervention info into the point layer, creating layer views, or another method?

Any suggestions or best practices would be greatly appreciated.

[KristalWalsh]

Hey @JohnThomas6 I have a similar relational database that is in design but it will depend on how your relates are established. For example, I have property boundaries related to activities performed inside the property that could be lines, areas or points. They are all one to many. Right now I filter from the specific activities table, but those records are related to the geometry, so it will yield the results. It's probably backwards and could be improved. So I think to answer your question the filter will work from the related table if it is related that way. Hopefully someone else will chime in. Good luck!