While creating a view object with the View Object Wizard or editing a view object in the View Object Editor, use the Attribute Settings page to edit the Java name and the database alias for a view object's attributes. You can also set the attribute's storage and updateability options.
Select Attribute
From the drop-down list, select the attribute you want to edit. The attributes contained in this list are the attributes that you selected in the previous Attributes panel. Once an attribute is selected, the properties of that attribute can be inspected and modified. Changes are automatically written to the view attribute when you click Finish.
Attribute
Name
The Java name this view object is referenced by.
Type
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 in the Attributes page's Selected list (these are the attributes that have been selected for this view object). To see this list, click Back.
If you deselect this checkbox, this attribute will not participate in the view object query statement. You can view this generated statement on the following Query page (click Next).
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.