Filter map points based on related table

Question

I’m using ArcGIS Experience Builder and trying to filter a points layer using a related table.

I have a filter widget where the user selects the route number, then route operator, which filters the route table.

I’ve configured a Filter Data Records Action in the Map widget where:

* Trigger data: Route table
* Action data: Bus stop points layer
* Condition: StopCode = ATCOCode

The route table is filtering correctly, but the points on the map are not being filtered to the matching records

Is this possible in Experience Builder?

D_Atkins · Answer

If you can't have a Hosted Feature Layer, then I'm assuming you're using Referenced Data from Enterprise...

In that case you could use the RDBMS to create a joined view while still maintaining the independent feature class and related table?

ElisJD · Answer

Thank you so much for this.

However, I can't have my points layer as a hosted layer. Any ideas if this is possible in this scenario?

D_Atkins · Answer

Off the cuff, I believe we've done this by creating a Joined View Layer; Create a Joined Hosted Feature Layer View in ArcGIS Online

There are some tradeoffs here, for sure, but at a basic level, the points would then have the relevant attributes from the Related Table to attach the Filter; you might even be able to power the Feature Table from the join-view layer.