For the audit related functions to take effect, you must select the Enable Audit option in the Audit tab in the Workflow Properties dialog, see Audit Tab(3.0).
Note!
The key or combination of keys are only unique within a batch. If a second batch is executed, a new row looking exactly the same as one from the previous batch might be received. The purpose of the key is to be able to save more than one row per batch.
For further information about Audit, see Audit (3.0).
AuditAdd
The auditAdd function increases or decreases a column value in any table specified. Note that the table must be configured in the Audit Profile Editor window first, and the column must be defined as a 'Counter'.
void auditAdd ( string profile, string tableAlias, string columnAlias, any value, any key1, //Optional any key2 ) //Optional
| Parameter | Description |
|---|---|
| The name of a defined Audit Profile. This declaration is case-sensitive. The |
| Name of the table to update. It is case-sensitive and it must exist in the specified Audit Profile. |
| Name of the column to update. The declaration is case-sensitive and must follow the names exactly as shown in the database. |
| The value to increase/decrease the existing value with. |
| The key columns in the order as entered in the Audit Profile Editor. |
Returns | Nothing. |
AuditSet
The auditSet function sets a column value in any table specified. Note that the table must be configured in the Audit Profile window first, and the column must be defined as being of type 'Value'.
void auditSet ( string profile, string tableAlias, string columnAlias, any value, any key1, //Optional any key2 ) //Optional
| Parameter | Description |
|---|---|
| The name of a defined Audit Profile. This declaration is case-sensitive. The |
| Name of the table to update. It is case-sensitive and it must exist in the specified Audit Profile. |
| Name of the column to update. The declaration is case-sensitive and must follow the names exactly as shown in the database. |
| The value to set. |
| The key columns in the order as entered in the Audit Profile. |
Returns | nothing. |
0 Comments