Reading Inserted objects with associated triggers

Certified Associate Developer

Hey There,

We are using triggers at the database to set values on insert (beyond just setting default values) however when saving data to the database using a!writeToDataStoreEntity the values set via these triggers are not being returned in fv!storedValues. Is there an additional XSD mappping that needs to take place to get hibernate to return the set value?

A couple of notes:

  • The trigger is BEFORE INSERT
  • We cannot move the trigger logic from the database to Appian
  • We are in the cloud and using MySQL
  • We tried ssing @GeneratedValue without success because..
  • The column the trigger is setting is NOT the primary key of the table

  Discussion posts and replies are publicly visible