First page Back Continue Last page Graphics

Restricting and Reordering the Columns Retrieved by a Query


Notes:

Restricting and Reordering the Columns Retrieved by a Query

The Attributes tab of the view object editor enables you to restrict the columns retrieved by the query by deleting attributes. You can also add attributes, either new ones or, for entity-based views, attributes based on columns that exist in the entity object. You can also change the order in which the attributes appear in the query statement.

The example in the slide shows an existing query that selects PRINCIPAL_NAME, TITLE, FIRST_NAME, LAST_NAME, and some other columns. After deleting and reordering attributes, the query is changed and no longer selects the deleted PRINCIPAL_NAME and TITLE columns, and the order in which LAST_NAME and FIRST_NAME are selected is reversed.