nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to join a hosted feature set with a table without loosing the attachments in the hosted feature set?

KevinLambeth1

I have a hosted feature set with photos attached that I am trying to join a field into. When I perform a "Join Features" as a hosted feature layer view the field is added but the attached photo is lost. Is there a way to keep the attached photo while performing the join in ArcGIS online?

Find more posts tagged with

Accepted answers

All comments

deleted-user-qpvAI3Fo0MKR

You might have more luck exporting your data to a .gdb and doing your ETL functions in ArcMap / Pro, and then re-uploading to AGO.

KevinLambeth1

We are trying to set this up for a client so that new data is automatically joined when it comes in through Survey123. We could easily export this into Pro, but need to have this run in real time.

deleted-user-qpvAI3Fo0MKR

Ah, that's indeed an added layer of complexity. I don't have any other insight for you, but I will be following this thread.

Good luck!

KevinLambeth1

While this would still be helpful, I found a workaround using an Arcade script in the popup configuration expression window to derive a link from the pre-joined feature set.

If anyone is interested here is a condensed snippet of the code (note I stripped out the serviceID since you will need your own):

var orig = FeatureSetById($map, /* Original */ "serviceID") //create feature set of pre-joined features
var filt = $feature.globalid //create the globalID filter key
var ary = Filter(orig, 'globalid = @filt') //filter the feature set to the globalID which should only give you an array of one
return first(ary).objectid //return the objectID from the original feature set to be used in generating a link. Note the first allows use of the .objectID call otherwise the scrip produced an error

KhaledHassen

Unfortunately we do not support returning attachments for join layer view.

I have added an enhancement in online feature service to support returning attachment for joined layer.

This will be supported for inner join only. Initial support plan will be UC this year. Also we might put a restriction like the left table needs to be the one with attachment.

Will update once we have this is finalized including testing.

Khaled Hassen

Online feature service lead

GIS_AdministratorCity_of_GP

Hi Khaled,

Has there been any update on this feature? We are placing points that have attached documents within polygons and joining them by an attribute. I am hoping that the new joined feature which is a polygon can have access to the points documents.

Thanks,

KhaledHassen

Sorry, we could not make it for online 7.2 release. But will update you shortly if we can make it in 7.3 release scheduled in Sept.

Thanks

Khaled

Jose_FranciscoSánchez_Díaz1

Hello Kevin,
Did you get this? I'm volunteering on a ONG and we are having problems with this issue. We are collecting data from arcgis survey 123 and we are not able to automatically show the data updated. Every time whe need to represent new data have to establish a new join on ArcGis online viewer and save results as a feature layer..
Thanks!

KevinLambeth1

Jose,

Unfortunately, we ended up moving away from related tables and just incorporating the data directly into the survey via modifications for the forms and webhook lookups that injected outside data. Sorry I can't be more helpful.

MattyMaps

Does this work now?

sophered

Does this work yet? @KhaledHassen

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.