Add filter to Joined View Layer

AaronGlanville

Hello,

First, I wanted to show some appreciation for the new Joined View Layers in ArcGIS Online. They are much more useful and easier (and free!) compared to the previous way of joining data through the analysis tools.

However, one improvement I would want to make to them would be the ability to apply to a filter to the Joined View Layer like you are able to apply to a regular View Layer. 

In web maps, of course you can still filter the data but our office uses an asset management system where it brings in services directly so we currently have no way consuming a filtered Joined View Layer. If this option was available, we would get much greater use out of this new feature.

Thanks

JeffShaw

Being able to filter join views would certain help. Because join views need to be created on the source feature layer rather than another view, they often can't be used. That's because we typically use views whenever sharing editable feature layers, and often they are configured so that only contributors can see or edit their own records. And in many cases when a view is shared publicly, it is filtered so that only QA'd, complete records are included. Without the ability to apply a similar filter or constraint on a join view, they are of even more limited use. A visualization filter could be applied in some cases but isn't a great alternative.

I say "of even more limited use" because in the organization that I administer with a few hundred creators, I know of only one case where join views are still used. Many of us have tried, but have abandoned them because of the untenable situation in which they need to be deleted in order to modify the layers being joined. Once deleted it is very difficult to rebuild any configurable apps that reference them. In short, they are just too problematic.

Creating Arcade data expressions in Dashboard is often the best alternative, and those can be embedded in Experience Builder, since ExB doesn't current support Arcade expressions.

The lack of support for relational data structures within ArcGIS Online and it's apps after all these years is appalling. It's the foundation on which the platform should have been designed from the start, as it's predecessors had been. Making join views actually useful would be a great step forward.