Query Hosted Feature Layer Based on Related Table?

[LianaSmith]

I have AGOL hosted layer and related table. I would like to filter layer based on the value from the related table. How can I do it?

Thanks!

[MicahBabinski]

Hi Liana,

It looks like Query widget—Web AppBuilder for ArcGIS | ArcGIS has you covered. Have you tried looking into that? It mentions that you can query and filter based on related table attributes.

Micah

[LianaSmith]

Hi Micah.

Thank you for you r reply. I tried using query, but I don't see fields from the related table when I try to do the expression.

And if I try to query related table, the layer itself doesn't get queried..

Thanks!

[MicahBabinski]

What was your data source selection when you configured the query? It looks like you might have to use the URL to the service that has the related table.

[LianaSmith]

I tried both: selecting the layer (There were no fields from related table to choose from) and I tried querying related table separately (layer was not adjusted based on this query)

[LianaSmith]

I forgot to mention, that I am not only trying to query but filter (so the features are changed on the map)  the layer as well