nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Enterprise - Postgres Trigger Workflow

KIVANC

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

Vind meer berichten getagd met

Accepted answers

MarlonAmaya

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

All comments

MarlonAmaya

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

KIVANC

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

MarlonAmaya

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.