<< Click to Display Table of Contents >> Navigation: Modules > Workflow Automation > Workflows > Threads > SQL Logs |
Each thread maintains three SQL logs. Each SQL log contains one or more blocks of SQL, which will be committed in the order in which it is written to the log. Once committed, each SQL block will have its DateCommitted updated, and will therefore not be committed again.
The three SQL logs are as follows:
Log |
Purpose and Use |
SQL |
Maintains one or more blocks of SQL statements which will be committed in the order in which they appear. SQL in this log must be expressly committed using the Commit Data to Database action. |
Approved SQL |
Maintains a block of SQL statements which will be committed in the order in which they appear upon determination of an overall request approval. SQL in this log is automatically committed. |
Denied SQL |
Maintains a block of SQL statements which will be committed in the order in which they appear upon determination of an overall request denial. SQL in this log is automatically committed. |