topic Re: ArcGIS Enterprise - Postgres Trigger Workflow in Geodatabase Questions

ArcGIS Enterprise - Postgres Trigger Workflow

KIVANC — Thu, 20 Apr 2023 14:28:59 GMT

I am working on a project where users enter data to a table using survey123 in ArcGIS Enterprise and I would like to have a trigger in postgres to auto-populate a second table whenever a row is inserted, which should be available in ArcGIS Enterprise as well. I believe since the table has objectID and GlobalID fields, my trigger function failed when I added data in ArcGIS Pro as a trial.

Appreciate any help regarding this. Maybe there is another logical approach that I am missing?

Thanks

Re: ArcGIS Enterprise - Postgres Trigger Workflow

MarlonAmaya — Thu, 20 Apr 2023 22:25:27 GMT

Hi @KIVANC

Look into using Attribute Rules if are you using ArcGIS Pro exclusively.

Attribute Rules (calculation rule)

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/an-overview-of-attribute-rules.htm

Share data with attribute rules

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/share-datasets-with-attribute-rules.htm

Marlon

Re: ArcGIS Enterprise - Postgres Trigger Workflow

KIVANC — Tue, 25 Apr 2023 15:29:43 GMT

Hi Marlon

Many thanks for your reply. I didn't know I could achieve this with attribute rules.

Do you by any chance know of any documentation regarding how I could define feature classes outside the one I am creating the rule for? As this is going to Enterprise and the datasets are in postgres, I don't know how to reference the layers.

For instance would this work say getting the data from test_layer?

var test_variable = FeatureSetByName($datastore, "test_layer")

Thanks

Kivanc

Re: ArcGIS Enterprise - Postgres Trigger Workflow

MarlonAmaya — Tue, 25 Apr 2023 15:55:55 GMT

Hi @KIVANC ,

Yes, if you want to reference another feature class, the FeatureSetByName would be used.

The following resources are helpful to review examples and review how different functions are utilized.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-rule-script-expression.htm

https://developers.arcgis.com/arcade/profiles/attribute-rule-calculation/

Marlon