Editing View Attribute Settings

While editing a view attribute in the Attribute Editor, use the View Attribute page to modify a view object attribute.

Name

This is the Java name this view object is referenced by.

Type

This is the Java datatype of this attribute. For normal mapped attributes this must match the type of the mapped entity object attribute.

Selected in query

This checkbox is selected when this attribute is mapped to a column. If you deselect this checkbox, this attribute will not participate in the view object query statement.

Updateable

The updateability of the attribute can be restricted further than that of the entity attribute. However, it cannot be made more updateable than the mapped entity object attribute.

Always

When this option is selected, the selected attribute may be updated.

While New

When this option is selected, the attribute can be updated only when it is part of a new, uncommitted row: the attribute can only be updated before it is written to a database object. After it is written, this attribute is essentially read-only.

Never

When this option is selected, the selected attribute may not be updated.

Query Column

The properties that relate directly to the SQL query are grouped here.

Alias

The name of the Query Result Set column.

Expression

A valid SQL expression used to define the value of a non-persistent (calculated) attribute.

Queriable

When this checkbox is selected, the selected attribute can participate in a query condition. If the columns (to which attributes of this domain type are mapped) can be part of a query filter (a WHERE clause), then this property should be selected. For example, this property should be selected for NUMBER column types, but not set for BLOB types. This attribute will be suppressed from Query by Form interfaces.