Is there a property for a feature class that shows if “Attachments” are enabled on that feature?

Question

Hi,

Am I missing something here is there a property for a feature class that shows if “Attachments” are enabled on that feature?

I have located the following properties but can find anything for attachments

datasetVersioned = arcpy.Describe(fc).isVersioned

inc.wriInfo('{0:<50} Feauture Class/Table - Versioned = {1}'.format(fc, datasetVersioned))

datasetArchived = arcpy.Describe(fc).IsArchived

inc.wriInfo('{0:<50} Feauture Class/Table - Archived = {1}'.format(fc, datasetArchived))

editorTrackingEnabled = arcpy.Describe(fc).editorTrackingEnabled

inc.wriInfo('{0:<50} Feauture Class/Table - Tracking = {1}'.format(fc, editorTrackingEnabled))

I am trying to report multiple Geo database schemas with varying objects in multiple Oracle SDE databases.

Can anyone tell me what is the best way to find out if objects have “Attachments” associated with it using ArcPy?

I could loop through all feature classes and see if there is an Attachment relationship class and an Attachment table but assume that there must be a better way then checking if there are Attachments enabled.

Many thanks for any suggestions

Adrian

PaulHaakma · Answer

Here's another way to achieve this using essentially a one liner.

Using the Data Access describe ensures we have a dictionary and can use the 'get' method to provide a fallback of an empty list if the relationshipClassNames key doesn't exist.

The code iterates over the strings in the relationshipClassNames list and checks if any match the baseName of the featureclass with '__ATTACHREL' at the end which indicates attachments are enabled.

The python 'any' keyword returns true if any of the strings match and false if none do.

This should therefore return true if there are attachments and false if not. It's essentially the same as previously suggested code, but some people prefer one liners and some prefer multiline if/else statements as more readable. Take your pick  😀

desc = arcpy.da.Describe(feature_class)
hasAttachments = any(value == f'{desc.get('baseName', '||')}__ATTACHREL' for value in desc.get('relationshipClassNames', []))

DavidTillberg_community · Answer

I'd recommend always using standard attachment table name.  Then you can check if <FeatureClass OR Table> + '__ATTACH' arcpy.Exists.

AdrianGay · Answer

Yes, you assume correctly...

At the moment the only solution that I can see is to loop over the feature classes by name and then see if there is also a

SDE Relationship Class of the form [NAME]_ATTACHEREL and a

SDE Table of the form [NAME]_ATTACH

But my assumption (which may be incorrect) is that there must be a better way from Esri to do this and to see if "Attachments" are enabled on an object.