topic Re: Is there a property for a feature class that shows if “Attachments” are enabled on that feature? in Python Questions

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

AdrianGay — Tue, 30 Jul 2019 08:48:37 GMT

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

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

DanPatterson_Retired — Tue, 30 Jul 2019 09:15:58 GMT

Adrian

I assume you are looking for something not on the list of functions or within the classes

Alphabetical list of ArcPy functions—ArcPy Functions | ArcGIS Desktop

Alphabetical list of ArcPy classes—ArcPy classes | ArcGIS Desktop

Haven't seen one

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

AdrianGay — Tue, 30 Jul 2019 09:41:29 GMT

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.

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

DavidTillberg_community — Fri, 30 Aug 2024 14:28:05 GMT

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

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

PaulHaakma — Wed, 15 Jan 2025 23:00:32 GMT

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', []))