Specifying a Custom Query for a View Object Definition

When you create a view object definition, JDeveloper assembles a query for you based on the entity object usages and view object attributes you have chosen. However, you can specify almost any valid SQL query for your view object definition.

To change the WHERE or ORDER BY clause of the query JDeveloper has assembled:

Open the View Object Editor by doing one of the following:
- In the System or Application Navigator, right-click the view object and choose E dit.
- On a diagram of business components, double-click the modeled view object. For more information on modeling business components, see About Modeling Business Components.
Select the Query node and enter your clauses. If you need further assistance, click Help.

To entirely change the query JDeveloper has assembled:

Open the View Object Editor by doing one of the following:
- In the System or Application Navigator, right-click the view object and choose E dit.
- On a diagram of business components, double-click the modeled view object.
Select the Query node.
Ensure that Expert Mode is checked, and enter your query. If
Note: Oracle ADF Business Components will use the following SQL to query the database:
```
SELECT *



FROM <QUERY>;                
```
where <QUERY> is the query you enter here. As long as this valid, the view object will function.
If your view object contains persistent view attributes (for more information, see the related topics list), select the Attribute Mappings node and ensure that the columns of your query are correctly mapped to entity attributes.

If you need further assistance on either page of the editor, click Help.