topic Query Hosted Feature Layer Based on Related Table? in ArcGIS Web AppBuilder Questions

Query Hosted Feature Layer Based on Related Table?

LianaSmith — Tue, 29 Aug 2017 21:04:18 GMT

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!

Re: Query Hosted Feature Layer Based on Related Table?

MicahBabinski — Tue, 29 Aug 2017 21:11:43 GMT

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

Re: Query Hosted Feature Layer Based on Related Table?

LianaSmith — Wed, 30 Aug 2017 19:22:53 GMT

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!

Re: Query Hosted Feature Layer Based on Related Table?

MicahBabinski — Thu, 31 Aug 2017 03:53:43 GMT

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.

Re: Query Hosted Feature Layer Based on Related Table?

LianaSmith — Thu, 31 Aug 2017 12:48:37 GMT

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)

Re: Query Hosted Feature Layer Based on Related Table?

LianaSmith — Thu, 31 Aug 2017 15:58:52 GMT

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