fData makes it possible to record a log of each execution of DSDs. The log is defined by adding an Audit Log data group to the DSD (in fact, a single DSD may have more than one audit log data group if appropriate).

The Audit Log data group records the following information automatically:

• Date/Time executed
• Account Id
• User Id (logged in user)
• Caller Id (a value that can be added as user data)
• DSD (the Id of the DSD being executed)
• Data Group recording the log
• Context (the type of usage of the DSD)
• Context Id (the id of the item executing the DSD)
• Context Data (the name of the item executing the DSD)

The possible contexts are:

• Abandon
• DSD (called from another DSD)
• Discover (fData designer discovery of fields for data group schema)
• fDocs
• fPanels
• fSheets
• fSheetsDSD (directly generated)
• fTest
• Menu
• Lookup
• Security

You can specify a log type and associated value. For example the log type may be “Client” and the log value could then be client's Id. In this way you can tag logs of a common type. This makes it possible to retrieve a log of a specific type and even (in this example) a specific client.

The entries allow for placeholders to be used to set or build the entry, or use a function using the Function Builder. Typically the log type would be an entered value and the log value would be a value taken from the data in another data group.

As well as the log type and value you may also want to record more data in the log. For example you may want to record the client's balance at the time the data was viewed.

Add a data item to the audit log data group for every value you wish to record in this way.

The Audit Data data group may be used to gather data from the audit log based on several selection criteria.