How to implement transactions in appian

Constraints :- Instead of using three separate Write Records nodes, configure all three records in a single Write Records node. This automatically creates one transaction, ensuring that if any write fails, all operations roll back while maintaining all record and database relations.


To understand sync record smart service first understand basics of sync record:-
Sync Records synchronizes data from your database into Appian’s record cache.
What is Sync? --> Appian maintains a cache layer of your database data. Instead of querying the database every time, Appian retrieves data from this cache. Much faster data retrieval and better performance
Database ← stores your actual data
Sync Records ← copies/updates data from database to Appian cache
Appian Cache ← fast, in-memory storage for quick access
Record View/Queries ← read from cache instead of database.

When you make database changes (especially outside Appian or bulk operations), you use Sync Records to update Appian’s cache with the latest database information like executing database insert script directly in database.

Constraints :- Instead of using three separate Write Records nodes, configure all three records in a single Write Records node. This automatically creates one transaction, ensuring that if any write fails, all operations roll back while maintaining all record and database relations.


To understand sync record smart service first understand basics of sync record:-
Sync Records synchronizes data from your database into Appian’s record cache.
What is Sync? --> Appian maintains a cache layer of your database data. Instead of querying the database every time, Appian retrieves data from this cache. Much faster data retrieval and better performance
Database ← stores your actual data
Sync Records ← copies/updates data from database to Appian cache
Appian Cache ← fast, in-memory storage for quick access
Record View/Queries ← read from cache instead of database.

When you make database changes (especially outside Appian or bulk operations), you use Sync Records to update Appian’s cache with the latest database information like executing database insert script directly in database.

Thanks, but my data is not the same type, so I use separate Write Records nodes.

If you are using the latest version of Appian, you can write to different types of record types—within the same schema—using a single Write Records smart service, by passing each as a separate pv! of type Record.

Can you give me a snapshot about this function? I am not find this function in my process model, I use the 25.2 version

Check release notes for 25.1

https://docs.appian.com/suite/help/25.1/Appian_Release_Notes.html#write-to-multiple-record-types-at-once



I tried writing multiple records of different type in single write record smart service.
For obvious reason write event will not work.

thanks

Let me know if that works for you.

I have tried it, it really useful. A tips for others, if the `Records Inputs` you passed contain null, it will error.  It's better to use reject to filter.

={ reject(
  a!isNullOrEmpty,
  {
    pv!list1,
    pv!list2,
    pv!list3,
  }
)}