topic Re: How to appropriate remove joins and add them back when customizing hosted feature fields... in ArcGIS Solutions Questions

How to appropriate remove joins and add them back when customizing hosted feature fields...

AdamCottrell — Fri, 17 Oct 2025 21:54:24 GMT

Is there a document/process that shows the how the ArcGIS solution Hosted Feature layers are joined? I need to remove the joins, add our specific fields and then recreate the joins. These joins are automatically created when a solution is deployed. My concern is that I may not correctly recreate the join. For example, I am looking at the Streetlight and Sign and Signal solutions that have the layers joined to tables.

Thank you.

Re: How to appropriate remove joins and add them back when customizing hosted feature fields...

DanielWickens — Tue, 21 Oct 2025 00:43:12 GMT

@AdamCottrell - We don't explicitly document how the join views are created.

The Sign_mainthistory and Pole_mainthistory views are both 1:M join views based on the globalid – assetglobalid relationship between the asset layer and the maintenance table, showing the entire maintenance history of the assets.

Here’s a snapshot of the settings for the Join Features tool in Map Viewer. Creating the Pole_mainthistory join view works the same as creating the Sign_mainthistory join view, just with the Poles layer and Pole maintenance table. Same applies to the join views in the Signal and Streetlight solutions.

Please reach out if you have any further questions.

Re: How to appropriate remove joins and add them back when customizing hosted feature fields...

AdamCottrell — Thu, 23 Oct 2025 20:27:39 GMT

Thank you Sir! I believe this is what I needed. I now need to test by removing the existing joins and add my needed attributes fields and then add the joins back. Again, thank you! I greatly appreciate it!