ExtendedPropertyValue

Summary

ArcPy class that provides access to the individual cell for extended and linked properties associated with the job.

Discussion

Extended and linked properties store business-specific information as part of the job that is not covered by the default job properties. Extended properties have one-to-one (1-1) cardinality, and there is one set of properties associated with the job. Linked properties have one-to-many (1-many) cardinality, and there are zero or more sets of properties associated with the job. Extended and linked properties are stored in a nonsystem geodatabase table in the Workflow Manager (Classic) repository.

Properties

Property	Explanation	Data Type
canUpdate (Read Only)	Indicates whether the cell is editable and can be updated.	Boolean
data (Read and Write)	The value (string, integer, or date) of the extended property cell.	Variant
displayOrder (Read Only)	The position of the field when displayed in ArcGIS Pro.	Integer
displayType (Read Only)	Indicates how the user will enter information into this field in ArcGIS Pro. default—Display type is based on the type of field added to the extended property table. text—Text value entered in a text box. date—Date value typed or entered using the date picker. domain—Select value from geodatabase domain presented in a drop-down list. file—Browse for a file and store file path as the value. geodataset—Browse for a geodataset and store its path as the value. folder—Browse for a folder and store its path as the value. tablelist—Select a value from a list of values in a table other than system table in the Workflow Manager (Classic) database. multi-level-tablelist—Select a value from a list of values in a table that further filters the values in the next field from the same table.	String
domain (Read Only)	The name of the geodatabase domain, if a domain exists for the field.	String
filter (Read Only)	In ArcGIS Pro when using a file browser to enter information, this filter will limit the types of files that are presented for selection.	String
ID (Read Only)	The object ID of the extended property record.	Integer
length (Read Only)	The field length of the extended property cell.	String
propAlias (Read Only)	The alias of the extended property field that is displayed in ArcGIS Pro.	String
propName (Read Only)	The name of extended property field.	String
required (Read Only)	Indicates whether a value for the field is required.	Boolean
tableListClass (Read Only)	The name of the geodatabase table containing the list of values displayed in a drop-down list for selection, when using a table list display type.	String
tableListDisplayField (Read Only)	The name of the field containing the value to be displayed in a drop-down list for selection, when using a table list display type.	String
tableListStoreField (Read Only)	The name of the field containing the value to store in the extended property field, when using a table list display type.	String
userVisible (Read Only)	Indicates whether the property is visible in ArcGIS Pro.	Boolean

Code sample

The following script updates the values for extended property cells.

import arcpy


#Establish a connection to a Workflow database
conn = arcpy.wmx.Connect(r'c:\test\Workflow.jtc')

#Access a Workflow Job with extended properties
job = conn.getJob(99999)

#Get the extended properties table associated with the job
prop_table = job.getExtendedPropertyTable('wmx.extra_properties')

#Update value of extended property fields
prop_table['parcel_number'].data=12345
prop_table['requestor_name'].data='Planning Commission'
prop_table['request_date'].data=datetime.datetime(2015, 4, 30, 12, 30, 45)
job.save()