Defining a New View Attribute

While creating a view object with the View Object Wizard or editing a view object in the View Object Editor, use the View Object Attribute dialog to define a new 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.

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.