topic Re: Filter (view) on related tables in ArcGIS Online Questions

Filter (view) on related tables

Nicole_Ueberschär — Thu, 21 Feb 2019 20:18:01 GMT

Related to my question Showing different views in web map depending on named user I am working now on the workaround.

I have a feature service with related tables. In the feature service are different sites that I can filter and save as a view but it would not filter the related tables. Now I filtered the tables in the web map but when I share the view of my table with the user that should only be able to see his site's data he can open the layer in the back end of AGOL and can still access the full tables. What can I do? I also tried with a query on the table before publishing but it is still uploading the full table. My (totally not satisfying solution) for now is to save the seperate sites with their related tables in extra feature services. This is not really a sustainable solution especially when the data will be updated sooner or later...

Besides, is there somehow a way to share only the final application with someone without giving them access to the sub products (feature service, web map,...) ? Ideally I would like to share only the final story map with the user that has the apps limited to his site. But as soon as he can see the base url of the story map he would also be able to login to the content page etc.

I am happy to hear what ever ideas you have to solve this...

Re: Filter (view) on related tables

ChristophRömer — Tue, 22 Dec 2020 15:42:49 GMT

i am also looking for a solution for years...

Re: Filter (view) on related tables

DPS_GIS_COORD — Mon, 22 Mar 2021 19:08:54 GMT

I think this link has the answers to your questions. This works really well to limit the amount of exposure you final application and the associated data have with public users. I'm not sure how well it works if you are sharing content with users inside of your organization, but you can give it a try.

https://support.esri.com/en/technical-article/000017029

Re: Filter (view) on related tables

ChristophRömer — Tue, 23 Mar 2021 07:18:43 GMT

I don't see the connection between your link and the problem of filtering related tables?

Re: Filter (view) on related tables

SarahPC — Fri, 16 Jul 2021 01:36:56 GMT

Did you ever find a solution? I have the same issue with not having the related tables filter by the view.

Re: Filter (view) on related tables

JoeStefanoni — Mon, 18 Apr 2022 17:25:33 GMT

I have a somewhat related question. Is it possible to filter a feature layer to display a selected subset from a related table? In my situation, there is a field called Program_Type in the related table and I only want to display those records in the main layer with a Program_Type value of DPCC. Is this possible using a filter or some other means?

Re: Filter (view) on related tables

JordanLandrum — Mon, 12 Feb 2024 18:33:45 GMT

@JoeStefanoni I'm trying to figure out the same thing. Did you ever come across a solution?