The following sections contain ArcGIS Arcade expressions that allow you to retrieve custom business-specific information from extended properties tables. For example, you can use an Arcade expression to insert a work order or purchase order information that's associated with a job into an email.
Note:
If you need to access job properties managed by ArcGIS Workflow Manager, you can access them using job property expressions.
JobExtendedProperty
The JobExtendedProperty expression returns the value of the specified extended property field for the specified job. The extended property table must be associated with the job template from which the job was created. This expression can only be used with one-to-one properties tables.
Note:
If you need to access one-to-many properties, use the JobRelatedProperty expression.
Parameters
JobExtendedProperty(job_id, table_name, field_name, {return_domain_description})
| Name | Explanation | Data type |
|---|---|---|
job_id | The ID of the job that contains the extended property table values you want to access. | String |
table_name | The name of the extended property table. | String |
field_name | The name of the field in the extended properties table. | String |
return_domain_description (Optional) | For a domain extended property field, the value's description is returned if the parameter is set to True. If the parameter is unspecified or set to False, the value's code is returned. | Boolean |
Output
Returns a string value for the extended property table field for the specified job. Fields in extended properties tables can contain string, integer, double, Boolean, datetime, and domain (string, integer, and double) data types.
Expression sample
The following expression returns the date that a purchase was submitted for the current job in epoch format:
JobExtendedProperty($Job, 'purchase_order', 'date')1589414631JobRelatedProperty
The JobRelatedProperty expression returns the value of the specified extended property field and row for the specified job. The extended property table must be associated with the job template from which the job was created. This expression can only be used with one-to-many properties tables.
Note:
If you need to access one-to-one properties tables, use the JobExtendedProperties expression.
Parameters
JobRelatedProperty(job_id, table_name, field_name, {row_id}, {return_domain_description})
| Name | Explanation | Data type |
|---|---|---|
job_id | The ID of the job that contains the extended property table values you want to access. | String |
table_name | The name of the extended property table. | String |
field_name | The name of the field in the extended properties table. | String |
row_id (Optional) | The ID of the row to be returned. The most recent record is returned by default. | String |
return_domain_description (Optional) | For a domain extended property field, the value's description is returned if the parameter is set to True. If the parameter is unspecified or set to False, the value's code is returned. Note:If you need to retrieve the return_domain_description without specifying the row_id, use empty quotation marks for the row_id parameter—for example, JobRelatedProperty($job, 'extProp', '', true). | Boolean |
Output
Returns a string value for the extended property table field and row for the specified job. Fields in extended properties tables can contain string, integer, double, Boolean, datetime, and domain (string, integer, and double) data types.
Expression sample
The following expression returns the current job's most recent population record for the city of Redlands:
JobRelatedProperty($Job, 'Redlands', 'Population')71198