Log Builder - Customize Log - Edit Column Definitions

The Log Builder screen will display every column for the selected table, in rows, with parameters for each column that control how the log displays them. Basically, a log is defined (customized) by defining how each of its columns are displayed, such as setting their visibility, their header title, width, whether or not their values are hyperlinks, and the order of their values (ascending or descending).

The following table provides descriptions of the parameters used to control a column’s display by the log.

Field Description

Visible

Specifies whether the column is visible in the log.

Display Order

Order in which the column will be displayed by the log.

Header

Column’s header, as it is to be shown by the log.

Header Alignment

Column header’s alignment (left, center, or right).

Width

Maximum number of characters that can be displayed by the column.

Alignment

Alignment for the data displayed in the column (left, center, or right).

Format Mask

Only relevant to columns with numeric values; this mask is a character literal that describes how numeric values should be formatted.

Frozen – Radio Button

This radio button is used to determine which of the first columns, with respected to the order of their display, are to be fixed (always displayed) when the table is scrolled horizontally. Only one column can be selected. The result is that the first column up to the column with this radio button selected remain fixed, when the remaining columns are horizontally scrolled through.

Wrap – Checkbox

Indicates whether the column data can wrap to the next line.

Searchable – Checkbox

Indicates whether the column can be searched against or not; only columns with this checkbox checked and that are visible are searched against when a user performs searches.

Total – Checkbox

Only relevant to columns with numeric values; if checked, the column will have a total of all of its values at the end of it.

Sort Order

For columns with numeric values, the entered value specifies the starting value from which the log will begin displaying the column’s values, in the order set by the Sort Direction field. For example, if a user would like to view Account Code column entries that start with a minimum value of 1000, and sorted by the direction specified by the Sort Direction field, enter 1000 for this parameter, for the Account Code column.

Sort Direction

Value that specifies how the column data should be sorted (ascending or descending)

Link

This field is used to specify an Enterprise module, using a screen call, to display information associated with the column’s value. If an application is specified, this column’s value, in the log, becomes a hyperlink to launch the selected application to display its associated information.

When finished setting all of the column parameters, click [Save].