Column+Properties Details

Element Details: Column+Properties

Available in: Logi Info

Source code name: ColumnProperties

Review or set properties for a particular table column. Set the ColumnName attribute to a column that exists in the table.

Build Index:

Set this attribute to build a standard index for the specified data column. If the column width is wider than 500 characters, use a full-text index instead.

Build Full Text Index:

Set this attribute to build a full-text index for this data column. A full-text index is required for table searches to consider individual terms within a field. By default, a full-text index is never generated until the user sets this attribute.

Data Type:

Set this attribute to specify this column's data type. Setting the data type is important for sort order and date arithmetic. By default, Logi Intelligence Server treats all data as "Text" type.

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

BuildFullTextIndex

True

False

Set this attribute to build a full-text index on this data column. A full-text index is required in order to search on individual terms within a data field. Note: Full-text indices should be built when configuring a table search with the Search element.

BuildIndex

True

False

Set this attribute to build a standard index on this data column.

ColumnName

UserDefined

(Required) The name of a column in the table.

ColumnWidth

UserDefined

Set this attribute to a numeric value that specifies the width for this text column. Note: Any column wider than 500 characters cannot be indexed. Use a full-text index for large text columns.

DataType

Text

Number

Date

(Required) Specifies the type of data present.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

PARENT ELEMENTS

Click element to drill down for more information.

Table

CHILD ELEMENTS

Click element to drill down for more information.