Previous Topic: <results> Element

Next Topic: <tool> Element

<column> Element

Defines a column in the Search Results screen, where the column values represent a field in the event record.

The supported entities are as follows:

name

Specifies a name that uniquely identifies the column in the Search Results screen.

Required: No

width

Specifies the preferred column width in the Search Results screen. For example:

width="20%" or width="120px"

Required: No

label

Specifies the column heading in the Search Results screen. For example:

label="Audit Status"

Required: No

hide_label

Specifies that the column heading label should not be shown, typically used when the column width is very narrow. For example:

hide_label="true"

Required: No

link_function

Specifies the predefined function that is called when a reviewer clicks an individual value in the results column. A range of standard scripting functions are supported—see Standard Scripting Functions.

For example, it is used by the Standard Search in the iConsole to show details about an email sender:

link_function="_UserDetails" 

Note: Can be used in association with the ref attribute.

Required: No

ref

Specifies the name of the column to be used as the unique reference for a 'column action'. The results element must include a column with this name (column names are specified using the name attribute).

If the ref attribute is omitted, a normal hyperlink is created.

For example, ref is used by the Standard Search in the iConsole to show details about an email sender:

ref="user_uid" 

Note: Always used with the link_function attribute.

Required: No

type

Specifies the type of column. This must be compatible with the associated database types; see Search Result Column Type Mappings.

The supported column types are:

Required: No

id

An identifier field containing values for the ref attribute.

text

Generic text field.

numeric

Generic numeric field.

date

Generic date field.

timestamp

Generic timestamp field.

icon

A two part field comprising the filename of the icon and a tooltip separated by a colon.

list

A list of values separated by semicolons.

link

A field which has a hyperlink to retrieve additional information such as user or event details. Link columns use the link_function attribute or display a popup.

Alternatively, if the ref attribute is not defined, the field is used as a URL to create a hyperlink to a page which is opened in a separate window. If required, the link can be displayed with alternative text (i.e. not the URL) by returning Label;URL as the column value.

quantity

A numeric field with unit information appended. For example, 123 MB, 30 days.

boolean

Generic Boolean field (that is, column values can be True or False).

real

A real (decimal) number, used in conjunction with the real-format attribute.

On Oracle 10 or later the value returned must be a fixed point value such as NUMBER(38,6). Real number columns are not supported on Oracle 9i due to driver limitations.

hidden

Specifies whether the column is hidden by default, for example:

hidden="true"

Note: Typically used for id columns.

Required: No

units

Specifies the units to be appended to column values, typically when used with a quantity column. For example:

units="%" 

Required: No

show_tooltip

Specifies that the full content of a cell is shown in a tooltip when the mouse pointer hovers over the cell. This is useful for narrow columns that contain very long values. For example:

show_tooltip="true"

Required: No

primary_key

Specifies that the column is a unique key. For the current release, this attribute is used to delete events from the Search Results screen (using the ToolbarDelete function) and for updating results (using the ToolbarUpdate function).

Required: No

icon_class

Specifies a subfolder containing the icon images for an 'icon' column type. This must be subfolder of the \images folder in the CA DLP installation folder on the iConsole front-end Web server.

Required: No

tooltip

Allows a tooltip to be defined for the column heading.

tooltip="My column tooltip"

Required: No

real_format

Specifies the format to be used for a real number using XML stylesheet formatting syntax. For example, '#.00' will format a number to 2 decimal places, 1234.5678 will be formatted as1234.57.

real_format="#.00"

Required: No

display

When this attribute is included, the column is optional. It specifies whether the column should be included in the displayed results. When set to "false" the column is not displayed in the search results unless selected from the Column Selector of the search results or search properties page.

display="false"

Required: No

style

Specifies a style for this column. This will be applied to both the headings and cell contents and is used typically to specify text formatting, for example:

style="text-align: center"

Required: No

total_function

Specifies the aggregate function to be used to calculate the total for this column. See Displaying Aggregate Totals.

Required: No

col_style_ref

Specifies a column in the results that will define the name of a CSS class in the stylesheet that will be used to define the style for each cell in this column.

The stored procedure is responsible for defining the class for each row; a NULL value will apply no class.

The precedence of certain styles (e.g. font-size) may need to be forced by using the '!important' rule.

.bigfont {font-size: x-large !important;}

Required: No