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?
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.
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..
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.
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.
Online Feature Service Dev. Lead
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
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.
Online feature service lead
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.