follow these stpes
1. Open “Set Transaction Status” in REFramework
- Navigate to the SetTransactionStatus.xaml workflow in the REFramework.
- After the “Set Transaction Status” activity, add a Database Update step.
2. Add Database Activities
- Install UiPath.Database.Activities if not already installed.
- Drag and drop “Connect” activity inside Init state (or use an existing connection).
3. Add “Execute Non Query” to Update Transaction Status
Inside SetTransactionStatus.xaml, add an “Execute Non Query” activity under each branch (Success, Business Exception, System Exception).
SQL Query for Updating Status
sql
UPDATE TransactionsTable
SET Status = @Status, UpdatedAt = GETDATE()
WHERE TransactionID = @TransactionID
Set Parameters
@Status→"Success","Business Exception", or"System Exception"@TransactionID→in_TransactionItem.SpecificContent("TransactionID")
4. Handle Each Scenario
- Success Path → Update status as
"Success" - Business Exception Path → Update status as
"Business Exception" - System Exception Path → Update status as
"System Exception"
5. Close the Database Connection
- Use “Disconnect” at the end of the process.
generated by LLM
cheers!!