I have record A and a record B on same source table but using different sync filters, all the DB writes and updates are happening through record A, so it is holding all the updated values, but record B is not getting synced to update the latest values.I tried establishing one to one relationship between record A and B, using same primary key, but still sync doesn't happen.
Is there any other way to sync the record B whenever an update happens to the source table through record A?
Discussion posts and replies are publicly visible
Record B won’t auto‑sync just because Record A updates the same table. Explicitly trigger a sync on Record B (a!syncRecords) on the primary‑key values after any update, so Record B explicitly pulls the latest data from the source.
which ever record type is configured in the write records will be synced. Hence record A is synced. If you want record B to be synced every time record A is updated the add a sync record smart service after write records A node so that record B is synced.
There is no automatic way to do this. Use a sync records node.
I dont think , we have that option in Appian to trigger record sync automatically, if any changes made in parent table it does not reflect in child table . But you can have scheduled record sync regularly for latest data or use record sync node
If you've configured 2 records on the same source table it should sync automatically but you need to use the same connected system.
Though you need to be sure that both Records are on the same version. You need to make sure they both have the schema specified. You can upgrade the record type by simply remapping the data source.
Shubham Aware Harsha Sharma Stefan Helzle Hima Appian recommends to use sync filters for limiting the rows in records based on required business logics, in this case records won't be in sync unless we specifically use a sync record smart service.If a main case table is being being planned for this scenario, then obviously it would be dependent in multiple process models or write records functions, so updating each one is going to be huge effort.
Thanks Mathieu Drouin , I tried updating the record to specify the schema like you suggested, but still the sync is not happening as expected.
Honestly, Patching every a!writeRecords() call with a!syncRecords() across multiple process models is a maintenance nightmare.You should try this :- Centralize all writes to one process -> call a!syncRecords() for both Record A and B after each write.OrConsolidate into one Record Type on the shared table -> control data visibility using sync filters, record-level security, or user filters at the interface level -> eliminates sync complexity entirely.
1. You can see the schema on both records?
2. You are using the same connected system for both Records?
Yes, I can see schema on both records and using same connected system for both records.1. 2.