Hi Gurus,
The Appian documentation (https://docs.appian.com/suite/help/22.4/record-type-relationships.html )states:
If you use a process model to delete a Customer from the database table, any Orders referencing that Customer would have an invalid foreign key. Therefore, the database will either cause the delete operation to fail and nothing will be deleted, or it will delete both the Customer and all Orders associated with that Customer. If the delete operation fails, no sync is needed because data has not changed. If it succeeds, Appian will immediately sync the deletions from both record types.
We defined a one to many relationship in the record type and a cascading delete in the database (mariadb) however data in the Orders table is not synced, do I miss something here? Btw not having a cascading delete in the database leaves the Orders records orphaned.
Any ideas?
Discussion posts and replies are publicly visible