Selectable Fields for Table Columns

For a list of selectables for columns in a table, enter print table selectable column; in MQL. Selectables for properties related to geometry and display apply only to User Tables. Selectables for properties related to URL links, settings, and user access apply to System Tables only.

Selectable Fields for Table Columns
Field Description Output

column.name

The column name

Value

column.description

The column description

Value

column.property[].*

The column properties

If property[ ] is specified, returns property names and values. If blank, returns all property names and values.

column.hidden

Is this column defined as hidden?

True/False

column.id

The column identifier

Value

column.user[].*

The user assigned to column

If user [] is specified, returns assigned user for column. If blank, returns assigned user for each column.

column.modified

The time and date the column was modified

Value

column.originated

The time and date the column was created

Value

column.type

The column type

Type assigned to column (always "Column")

column.number

The number assigned to column based on its creation order in table

Value

column.label

The column label

Value

column.value

The synonym for column label

Value

column.selectedvalue

[Unused]

 

column.expression

Expression (select statement) associated with column

Type of selectable item (attribute, description, etc.)

column.expressiontype

Type of object expression applies to

Business object or relationship

column.font +

Font used to display column data

Value

column.editable

Is the column editable?

True/False

column.multiline

Can field display more than one line?

True/False

column.minwidth +

Minimum width of column

Value

column.minheight +

Minimum height of column

Value

column.autowidth

Does the column width autosize?

Standard Tables: True/False. System Tables: True

column.autoheight

Does the column height autosize?

Standard Tables: True/False. System Tables: True

column.absolutex +

Is horizontal location value absolute?

True/False

column.absolutey +

Is vertical location value absolute?

True/False

column.xlocation +

The horizontal location of field (left side)

Value

column.ylocation +

The vertical location of field (top)

Value

column.width +

The width of column in unit specified for table

Value

column.height +

The height of column in unit specified for table

Value

column.href ‡

The column's href

URL plus parameters

column.alt ‡

The column's alt

Alt text

column.range ‡

JSP that gets a range of values and populates column with selected value.

JSP name

column.update ‡

The page to display after column is updated

URL

column.setting[].* ‡

Associated settings

If setting [] is specified, returns setting names and values. If blank, returns all setting names and values.

+ Available only for (Standard) User Tables ‡ Available only for System Tables