Next: Outgoing email formats, Previous: Named query definitions, Up: dbconfig file [Contents][Index]
These formats are similar to the named query formats, but they include more options. They are used for formatting audit-trail entries and for outgoing email messages.
There is currently only one audit-trail format, defined by the
audit-trail-format option:
audit-trail-format {
format "formatstring"
[ fields { "fieldname" [ "fieldname" ... ] } ]
}
For those fields that require an audit-trail entry, the audit-trail text
to be appended is formatted as described by this format. The per-field
audit-trail-format is used in preference to this one, if it
exists.
formatstring and fieldname are similar to those used by
the named query format. fieldname may also be a format
parameter, which is a context-specific value. (Format parameters are
distinguished from fieldnames by a leading dollar sign (‘$’)).
The following format parameters are defined for
audit-trail-format entries:
$FieldnameThe name of the field for which an audit-trail entry is being created.
$OldValueThe old value of the field.
$NewValueThe new field value.
$EditUserEmailAddrThe email address of the user editing the field. Set by the
EDITADDR gnatsd command or from the responsible
file; if not available, user’s local address is used.
$CurrentDateThe current date.
$ChangeReasonThe reason for the change; may be blank if no reason was supplied.
These parameters may be used anywhere a fieldname can appear.