# Mapping View Attributes to SQL Columns

While editing a view object in the View Object Editor, use the Attribute Mapping page to have explicit control over the mapping of Query result columns to the underlying entity objects and their attributes. This mapping is managed automatically for you unless you are working in expert mode. (In the previous Query panel, select the Expert Mode checkbox.)

Query Columns

> This is a list of the columns that the current query produces. Each of these columns needs to map to a view object attribute. The attribute can be persistent, and thus allow the view updates to be routed back into an entity object row, or the view attribute can be transient, in which case no updating is done.

View Object Attributes

> A list of the view object attributes that are mapped to each of the columns of the query result. Selecting a cell in this list brings up a control that allows you to select the view object attribute to be mapped to this column of the query result.

> One of the choices in the mapping control list is Not Mapped. This will create a new calculated attribute that has the name of the Query Column that it is mapped to. Selecting this option makes this column of the query result non-persistent.