topic Re: How to access data from other tables or layers? in ArcGIS Workflow Manager Questions

How to access data from other tables or layers?

Ulises — Thu, 01 Aug 2024 20:02:28 GMT

We have a table that stores 2 fields with the required information: regional office and region email.

Example:

REGION	EMAIL
region 1	email 1
region 2	email 2

Our workflow documents the regional office for each assigned job as an extended property that is updated when the supervisor create the job. Is there a was to linked or access the region email information (or any other value for that matter) at an specific step? The idea is that depending on the regional office assigned to a job, when a step runs a notification is send to that regional office email.

Thanks in advance.

Re: How to access data from other tables or layers?

MargoHuang — Mon, 12 Aug 2024 14:24:11 GMT

Hi Ulises,

I believe you can use this Arcade function -

JobExtendedProperty(job_id, table_name, field_name, {return_domain_description})

Please check out ESRI documentation here. Extended property functions

Hope this helps!

Margo

Re: How to access data from other tables or layers?

Ulises — Tue, 20 Aug 2024 13:26:59 GMT

Hi Margo,

thanks for the feedback. Not sure if this works since I do not capture the email in the extended properties, just the region name. Each region has a specific email address. I haven't found a way to automatically insert email 1 for region 1 in the correspondent attribute.

Re: How to access data from other tables or layers?

MargoHuang — Tue, 20 Aug 2024 20:30:03 GMT

I see. How many regions do you have? If there is not a lot, I will create a dictionary using region as key and email as value. And use Arcade to get the email from the dictionary based on region input. Hope this helps!

Margo