Audit lite in Jitterbit App Builder
Overview
Audit Lite is an App Builder feature that provides a way to track changes to a table. Specifically, the following information is tracked:
Usage Type | Description |
---|---|
AddedBy | The username of the person who added the record. |
AddedOn | The date the record was added. |
ChangedBy | The username of the person who last modified the record. |
ChangedOn | The date the record was modified. |
Along with tracking the data above, App Builder provides a way to display Audit Information for Grid and Form panels.
Security
Users who have permission to read data from a table that contains Audit Information will have permission to view Audit Data.
Configuring audit lite
Add audit lite columns to physical table
App Builder will automatically add the following Audit Lite columns upon table creation:
AddedBy
AddedOn
ChangedBy
ChangedOn
Note
The column names are suggestions - there is no requirement to use those names. Also the physical data type may vary depending on the Data Source used.
Add audit lite to panel
To show Audit Lite in a Grid or Form panel, do the following:
- Navigate to Action Drawer > Live Designer
- Select the panel
- From the Live Edit region on the right, click the Built-In tab
- Check to enable Show Audit
Note
If you do not see the checkbox, the backing physical table for this panel does not have Audit Lite columns. Double check that the table configuration is correct.