addedValuesDocs

 
Home

Variables

Forms

Reports

Queries

Groups

Globals

Preferences

Triggers

Updaters

Audit Tables

Timed Tasks

Import

Export

Remote Search

Tropes

Help

Macros

Report a Bug

 
 

addedValues Audit Tables in addedValuesDocs.

An Audit Table is a read only table of records, resembling a log or a database audit trail. Each record can have values described by variables, whose values can be indexed and thus searched for with forms and queries, and which can be used to generate reports. Defining an Audit Table means giving it name which is always the name of a group, so as a side effect creating a new table may create a new groupname, and allocating space to store the records.

before data can be stored into an audit table, you need to define variables it. You may do this manually from the variables page, or you copy the definitions of a set of variables for a given group and attribute type here. This is useful because typically data is copied from another entity such as a message or user transaction , and a postprocessor such as formToAudit can match names to decide what to place in the audit.

Records are assigned to an Audit Table by a special scripts written for each specific purpose, and oncw written they cannot be modified using addedValues web interface. The audit table, including all the data currently held, can be deleted here, unless forms, reports and queries have been defined using the audit table variables.


New Audit Table : 
 



Create your own Manila site in minutes. Everyone's doing it!