Filtering Points Based on Related Table Field in AGOL

JohnThomas6 — Tue, 19 Aug 2025 19:41:48 GMT

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.

Re: Filtering Points Based on Related Table Field in AGOL

KristalWalsh — Wed, 20 Aug 2025 15:21:55 GMT

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!

topic Re: Filtering Points Based on Related Table Field in AGOL in Web AppBuilder Custom Widgets Questions

Filtering Points Based on Related Table Field in AGOL

Re: Filtering Points Based on Related Table Field in AGOL