Selecting features not having attachments from a hosted feature layer

DavidLitke

I have a hosted feature layer enabled for attachments. I would like to QA the dataset in ArcGIS Pro to check for features not having attachments. I understand you can use an SQL clause in Pro something like: GLOBALID NOT IN (SELECT REL_GLOBALID FROM MYTABLE__ATTACH), but I can't see the ATTACH table in a hosted feature class.

KellyGerrow

Hi David,

There isn't an automated way to do this currently.

You could query each item to see if there are any attachment infos and input a flag to easily filter this information in an application.

Check out this sample that Jake Skinner‌ wrote which may have the starting logic that you need Show Attachments in Web Map Popup‌

REST API Calls:

Attachment Infos (Feature Service)—ArcGIS REST API: Services Directory | ArcGIS for Developers 

Update Features—ArcGIS REST API: Services Directory | ArcGIS for Developers 

Also, I'd suggest submitting an Idea on https://community.esri.com/community/arcgis-ideas?sr=search&searchId=816c862a-1aea-4488-bb74-37015671a4d7&searchIndex=0‌ .

-Kelly