topic Re: Is there a way to join a hosted feature set with a table without loosing the attachments in the hosted feature set? in ArcGIS Online Questions

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

KevinLambeth1 — Thu, 21 Feb 2019 21:52:01 GMT

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?

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

deleted-user-qpvAI3Fo0MKR — Thu, 21 Feb 2019 22:19:42 GMT

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.

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

KevinLambeth1 — Thu, 21 Feb 2019 22:49:45 GMT

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.

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

deleted-user-qpvAI3Fo0MKR — Fri, 22 Feb 2019 14:08:56 GMT

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!

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

KevinLambeth1 — Fri, 22 Feb 2019 15:18:49 GMT

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

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

KhaledHassen — Fri, 22 Feb 2019 17:06:17 GMT

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

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

GIS_AdministratorCity_of_GP — Wed, 24 Jul 2019 16:51:18 GMT

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,

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

KhaledHassen — Thu, 25 Jul 2019 16:54:54 GMT

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

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

Jose_FranciscoSánchez_Díaz1 — Thu, 28 Nov 2019 00:00:46 GMT

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!

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

KevinLambeth1 — Thu, 28 Nov 2019 00:44:15 GMT

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.

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

KhaledHassen — Sat, 30 Nov 2019 15:48:16 GMT

FYI, join view support attachments. This requires the PKEY/FKEY to be based on globalId.

We have released this in online 7.3 release (Sept. 2019). Pl. check it out and let us know if you still have any issues.

Khaled Hassen

Online Feature Service Dev. Lead

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

MattyMaps — Tue, 06 Jun 2023 17:45:00 GMT

Does this work now?

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

sophered — Wed, 15 Oct 2025 18:42:48 GMT

Does this work yet? @KhaledHassen